Post reply

Can we implement Clustered Index on Unique key ?

  • January 4, 2012 at 11:28 pm

    #248398

    Hi,

    Can we implement Clustered Index on Unique key ? If no... why ?

    Regards,

    Sachin.

  • January 4, 2012 at 11:39 pm

    #1428796

    Yes.

  • January 5, 2012 at 12:16 am

    #1428804

    I think no...because clustered index only follow primay key.

    Expect answer from other more.....

  • January 5, 2012 at 1:59 am

    #1428829

    Yes, you absolutely can. You can have clustered unique constraints, clustered normal indexes, nonclustered primary keys. There's nothing requiring the cluster to be on the primary key.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 5, 2012 at 2:25 am

    #1428842

    thanks a lot...

  • January 5, 2012 at 2:30 am

    #1428844

    Hi,

    How many nonclustered index we can implement on one column like "id" as per my below given table structure.

    My table structure is : -

    field datatype

    ---------------------

    id int

    name1varchar

    name2varchar

    ------------------------

    abcd nonclustered located on PRIMARY name1

    abcde nonclustered located on PRIMARY id

    abcdef nonclustered located on PRIMARY id

    IX_ta nonclustered, unique, unique key located on PRIMARYid

    PK_ta clustered, unique, primary key located on PRIMARYid

  • January 5, 2012 at 2:31 am

    #1428845

    Hi Gail Shaw ,

    Expect answer from your side.

    Thanks in advance.

  • January 5, 2012 at 2:40 am

    #1428848

    kumar.sachu08 (1/5/2012)

    ...How many nonclustered index we can implement on one column like "id" ...

    Why would you want more than one index on the same column?

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

  • January 5, 2012 at 2:51 am

    #1428852

    kumar.sachu08 (1/5/2012)

    How many nonclustered index we can implement on one column like "id" as per my below given table structure.

    249 in SQL 2005. The question is, why on earth would you want to.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 5, 2012 at 2:51 am

    #1428854

    I can't ask from interviewer :

    Why would you want more than one index on the same column?

    Such type of question come in mind after interview.

    Interviewer ask me simply how many non clustered index apply on one column.

  • January 5, 2012 at 2:52 am

    #1428856

    kumar.sachu08 (1/5/2012)

    I can't ask from interviewer :

    Why would you want more than one index on the same column?

    Sure you can, and if anyone asked me such a downright silly question in an interview that would be my exact reply.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 5, 2012 at 5:10 am

    #1428917

    expect reply with someone...please help me.

  • January 5, 2012 at 5:25 am

    #1428927

    Reply to what?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 5, 2012 at 5:40 am

    #1428937

    kumar.sachu08 (1/5/2012)

    I can't ask from interviewer :

    Why would you want more than one index on the same column?

    Such type of question come in mind after interview.

    Interviewer ask me simply how many non clustered index apply on one column.

    Just a PS, if you can't answer those questions and worse, can't find the answers on your own you are nowhere near ready to be a DBA.

Viewing 14 posts - 1 through 13 (of 13 total)

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