hint no_unnest, push_subq, push_pred

最新推荐文章于 2021-09-27 23:00:15 发布

转载最新推荐文章于 2021-09-27 23:00:15 发布 · 136 阅读

本文深入探讨了USE_CONCAT提示的作用，它如何通过使用UNION ALL操作符来转换带有OR条件的查询，以及如何禁用IN列表处理和展开所有析取项。此外还介绍了bypass_ujvc的相关内容。

http://space.itpub.net/15415488/viewspace-663969

http://www.itpub.net/thread-1391316-1-1.html

swap_join_inputs

USE_CONCAT
)u"B+~rz J22936840The USE_CONCAT hint forces combined OR conditions in the WHERE clause of a query to be transformed into a compound query using the UNION ALL set operator. Generally, this transformation occurs only if the cost of the query using the concatenations is cheaper than the cost without them.
N q+e7C}#^EP` t22936840The USE_CONCAT hint disables IN-list processing and OR-expands all disjunctions, including IN-lists.
s&[k'yQQ)Y22936840

bypass_ujvc

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22936840/viewspace-750093/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22936840/viewspace-750093/