1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

PK in oracle with no other indexes is clustered or non-clustered?

Discussion in 'General' started by ppargai, Mar 15, 2011.

  1. ppargai

    ppargai Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    If I create a primary key on a table in oracle 10g without any other indexes.Will this key will get created as clustered or non-clustered?

    Thanks a Lot,
    Prerana
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    There is NO 'clustered index' type in Oracle; if you want that behaviour then create an index-organized table. Primary keys in any other table type are normal b-tree indexes. Such 'clustered indexes' are the domain of Sybase and SQL Server.