Oracle index hint syntax
Question: I added an index hint in my query, but
the hint is being ignored. What is the correct syntax for an index hint
and how do I force the index hint to be used in my
query?
Answer: Oracle index hint
syntax is tricky because of the index hint syntax is incorrect it is treated as
a comment and not implemented. Here is an example of the correct syntax
for an index hint:
select /*+ index(customer
cust_primary_key_idx) */ * from customer;
Also note that of you alias the table, you must use the
alias in the index hint:
select /*+ index(c
cust_primary_key_idx) */ * from customer c;
Also, be vary of issuing hints that conflict with an
index hint. In this index hint example, the full hint is not consistent
with an index hint:
select /*+ full(c)
index(c cust_primary_key_idx) */ * from customer c;
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
