Select *
FROM dba_ind_columns
Where index_owner='TEST73' AND table_name=upper('tx_log_t')
可以查询数据库的表上面的索引字段。
参考博文:
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;
总结
如果觉得编程之家网站内容还不错,欢迎将编程之家网站推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。