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!

How to check already created primary key is clustered or not in oracle 10g

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

  1. ppargai

    ppargai Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    Can some please suggest how to check if a already created PK is clustered or not in Oracle 10 g .
    Also if there is some option to check clustered/non-clustered index in pl-sql developer?
     
  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 in Oracle, at least not as there is in SQL Server. One can create an index-organized table which requires a primary key; such a table type sets the leaf nodes as the table data (which a clustered index in SQL Server also does) however it's not a 'clustered index', it's a table.
     
  3. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    @ ppargai :

    Here is a briefing on INDEX-ORGANIZED TABLES. You can check the user_tables data dictionary to check whether the table is index-organized or not.