Post reply

clustered index confussion

  • January 14, 2010 at 12:20 am

    #219248

    hi all,

    please help on below

    it is possible to create clustered index on col which does not have defined primary key ?

    and

    it is possible to create clustered index on col which have applied check/Unique ?

    Regards,
    Shivrudra W

  • January 14, 2010 at 12:26 am

    #1103453

    Shivrudra (1/14/2010)

    hi all,

    please help on below

    it is possible to create clustered index on col which does not have defined primary key ?

    and

    it is possible to create clustered index on col which have applied check/Unique ?

    The clustered index does not have to be on the Primary Key

    and

    You may create a clustered index on a Unique column (a PK is also a Unique).

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply