我们可以在oracle中添加关于索引的注释吗？(Can we add comments on index in oracle?)

我们可以在oracle中添加关于索引的注释吗？(Can we add comments on index in oracle?)

我在oracle中有一个索引说“TEMP_INDEX”，我想在其上添加一条评论，如“OBSOLETE”，这样我就可以忽略这个索引进行进一步处理。

我们可以这样做吗？ 或者还有其他方法可以做到这一点。

这里的目标是，我只想以某种方式标记索引，以便不考虑进一步处理。 这里的约束是，我无法删除该索引。

I have one index in oracle say "TEMP_INDEX" and i want to add one comment on it like "OBSOLETE" so that i can ignore this index for further processing.

Can we do this? or is there any other way to do this.

Here the aim is, i just want to mark index in some way so that it won't be considered for further processing. Here the constraint is, i can't delete that index.

最满意答案

您可以简单地禁用索引

alter index TEMP_INDEX invisible

或者如您所述，您不希望系统将该索引视为进一步处理，您可以在查询中使用NO INDEX hint

参考ORACLE GUIDE - >

SELECT /*+ NO_INDEX(employees emp_empidx) */ employee_id FROM employees WHERE employee_id > 200;

You can simply disable the index by

alter index TEMP_INDEX invisible

OR as you mentioned that you don't want the system to consider that index for further processing you can use NO INDEX hint in your query

Referenced from ORACLE GUIDE ->

SELECT /*+ NO_INDEX(employees emp_empidx) */ employee_id FROM employees WHERE employee_id > 200;