This content has been marked as final. Show 3 replies
843178 wrote:There are several things that can create indexes for you, like when creating materialized views or primary keys etc.
I found some index "IDX$$_00010001" for some table, but it seems like a index create by system because I can't find any statement for creating this index. could you please tell me where this index comes from?
Easiest thing is, if you have tool like TOAD etc. get it to generate the DDL (script) for the table which the index is against and you should be able to see what non-user-created indexes are created on the table due to other things.