Post reply

Indexes in Sql server 2005.

  • October 21, 2010 at 12:26 pm

    #141203

    Hi,

    Can we create non-clustured index on a clustered index ?

    Subha

  • October 21, 2010 at 1:13 pm

    #1240542

    Not that I am aware of. Why would you want to do this? You could create a duplicate index on the source table but not on the clustered index.

    Chris Shaw

  • October 21, 2010 at 1:15 pm

    #1240544

    Indexes are created on tables or views, not on other indexes.

    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

  • October 21, 2010 at 1:26 pm

    #1240552

    Um, wha? What are you trying to do? As already mentioned, the answer is no, not exactly, though kinda yes, because non-clustered will include the clustered as a lookup. But you wouldn't define it that way...

    or do you mean something like:

    CREATE CLUSTERED INDEX idx_1 ON tbl1 (col1, col2)

    and then do:

    CREATE NONCLUSTERED INDEX idx_2 on tbl1 (col1, col2)

    Can you do this? Yes. Would you do this? No. Pointless.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

Viewing 4 posts - 1 through 3 (of 3 total)

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