Can we add comments on index in oracle?

Question

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.

Answer 1

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;