Oracle查询数据库的索引字段以及查询用索引

Select  *
FROM dba_ind_columns
Where index_owner='TEST73' AND table_name=upper('tx_log_t')

可以查询数据库的表上面的索引字段。

参考博文：

http://www.dba-oracle.com/t_oracle_index_hint_syntax.htm

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;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!