3 Replies Latest reply on Jan 3, 2013 4:57 PM by stefan nebesnak

    index issue

    846181
      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
          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
          1 person found this helpful
          • 2. Re: index issue
            BluShadow
            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
              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
              1 person found this helpful