This discussion is archived
3 Replies Latest reply: Jan 3, 2013 8:57 AM by stefan nebesnak RSS

index issue

846181 Newbie
Currently Being Moderated
Hi expert,

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?

Many Thanks,
Andy
  • 1. Re: index issue
    L-MachineGun Pro
    Currently Being Moderated
    843178 wrote:
    Hi expert,

    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?

    Many Thanks,
    Andy
    Did you check in DBA_INDEXES?
    :p
  • 2. Re: index issue
    BluShadow Guru Moderator
    Currently Being Moderated
    843178 wrote:
    Hi expert,

    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?
    There are several things that can create indexes for you, like when creating materialized views or primary keys etc.

    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.
  • 3. Re: index issue
    stefan nebesnak Journeyer
    Currently Being Moderated
    Oracle Database enforces a UNIQUE key or PRIMARY KEY integrity constraint on a table by creating a unique index on the unique key or primary key.

    This index is automatically created by the database when the constraint is enabled.

    http://docs.oracle.com/cd/B28359_01/server.111/b28310/indexes003.htm

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points