Analyze schema v/s Rebuild Indexes - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Analyze schema v/s Rebuild Indexes

  1. #11
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    It is important that the indexes are rebuilt, and in the course, the index on the primary key is rebuilt.

    But you don't rebuild the PKs themselves.

    This is sort of a namegame.

    David Knight
    OCP DBA 8i, 9i, 10g

  2. #12
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Is it correct that whenever a Primary Key is created a corresponding Index is created.

    Am I correct when i say this.
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  3. #13
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Yes, an index is created when a primary key is created or enabled.

    -Ken

  4. #14
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Index is created together with primary key only if appropriate index is not allready present in the system. If an index that covers PK constrained columns is allready there, PK uses this existing index to inforce the constraint. And in this case index does not need to be created as an unique index.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #15
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    True.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width