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 PK is clustered or not in oracle?

Discussion in 'SQL PL/SQL' 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. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    I hope you got the answer ..
     
  3. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    The only equivalent to SQL Server's clustered index in Oracle is the Index-Organized Table; there the Primary key is required and is the basis for the table structure (the leaf nodes are the table data). There are clusters in Oracle but those are completely different from what you are asking. Any stand-alone index in Oracle is not 'clustered' as there is no such index type available.