DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: tamilselvan -Starting from 8i, an index on PK is not mandatory.

  1. #1
    Join Date
    Nov 2000
    Posts
    33
    Hi Tamilselvan

    Starting from 8i, an index on PK is not mandatory.

    Does it work same as normal primary key ?
    What is the synetx of creating this kind of PK ?
    Will it work on Oracle8i workgroup also ?

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    [QUOTE][i]Originally posted by anujpathak [/i]
    [B]Hi Tamilselvan

    Starting from 8i, an index on PK is not mandatory.
    [/B][/QUOTE]

    Can you elaborate this? AFAIK, Oracle still enforces PK and UK constraints *only* by using indexes. The only difference in 8i is that the index does not need to be unique any more, so that the enforcement of the constraint can be deferred.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    What I intended to inform you was we could have a table and its PK index in one storage place. This can be achieved through Index Organized table.
    Index-organized tables are like regular tables with a primary key index on one or more of its columns. However, instead of maintaining two separate storage spaces for the table and B*tree index, an index-organized table only maintains a single B*tree index containing the primary key of the table and other column values.

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