swap_join_inputs
USE_CONCAT
)u"B+~r z 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}#^E P` t22936840The USE_CONCAT hint disables IN-list processing and OR-expands all disjunctions, including IN-lists.
s&[k'yQQ)Y22936840
)u"B+~r z 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}#^E P` t22936840The USE_CONCAT hint disables IN-list processing and OR-expands all disjunctions, including IN-lists.
s&[k'yQQ)Y22936840
bypass_ujvc
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22936840/viewspace-750093/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
index about null
下一篇：
execution plan
请登录后发表评论
登录
全部评论
