Contact Us
Contact us at： [email protected]
After waiting several minutes, and querying the DBA_INDEXES view again, it shows that the helpful index has been made visible:
INDEX_NAME VISIBILITY
SYS_AI_gc454q9xmxbqv VISIBLE
We can verify that this index is in use by generating an execution plan. For example:
SQL> set autotrace trace explain;
SQL> select d from d where d = 100;