/*+unnest*/

/* unnest */是Oracle SQL中的一种提示(Hint)。它的位置应位于子查询所在的Query Block中。通过使用/* unnest */提示，可以告诉Oracle优化器在执行查询时将子查询展开为一部分，而不是作为单独的查询块。这可以提高查询性能和效率。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [Oracle SQL调优系列之no_unnest和unnest用法简介](https://blog.csdn.net/u014427391/article/details/103936511)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *2* *3* [Oracle中常见的Hint (二)](https://blog.csdn.net/weixin_41799903/article/details/88977145)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]