clustered index - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

clustered index

Author

Topic

subhaoviya
Posting Yak Master

135 Posts

Posted - 2012-02-17 : 00:48:24

Why we not able to have more than one clustered index for a table?

thanks in advance
subha

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-02-17 : 00:51:29

Because the clustered index is the table. Why do you need more than one? You can sort of do it with this: http://weblogs.sqlteam.com/tarad/archive/2009/11/09/Multiple-ldquoclusteredrdquo-indexes-on-a-SQL-Server-table.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-17 : 13:42:47

quote:
Originally posted by tkizer

Because the clustered index is the table. Why do you need more than one? You can sort of do it with this: http://weblogs.sqlteam.com/tarad/archive/2009/11/09/Multiple-ldquoclusteredrdquo-indexes-on-a-SQL-Server-table.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Tara
Can you please tell any one case where we really want to do this? I've thought a bit and cant make out when one needs to create multiple clustered indexes?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-02-17 : 13:48:51

quote:
Originally posted by visakh16

quote:
Originally posted by tkizer

Because the clustered index is the table. Why do you need more than one? You can sort of do it with this: http://weblogs.sqlteam.com/tarad/archive/2009/11/09/Multiple-ldquoclusteredrdquo-indexes-on-a-SQL-Server-table.aspx

Tara
Can you please tell any one case where we really want to do this? I've thought a bit and cant make out when one needs to create multiple clustered indexes?

I haven't a clue actually. I've never used it, but it came up in a discussion with a MS engineer (SQL Server expert), so shared it in a blog article.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-17 : 13:56:00

quote:
Originally posted by tkizer

quote:
Originally posted by visakh16

quote:
Originally posted by tkizer

Because the clustered index is the table. Why do you need more than one? You can sort of do it with this: http://weblogs.sqlteam.com/tarad/archive/2009/11/09/Multiple-ldquoclusteredrdquo-indexes-on-a-SQL-Server-table.aspx

Tara
Can you please tell any one case where we really want to do this? I've thought a bit and cant make out when one needs to create multiple clustered indexes?

I haven't a clue actually. I've never used it, but it came up in a discussion with a MS engineer (SQL Server expert), so shared it in a blog article.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Ok..Anyways thanks for the link
I've bookmarked it already

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-02-17 : 15:32:02

Before INCLUDEd columns I can imagine reasons.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-17 : 16:00:03

quote:
Originally posted by russell

Before INCLUDEd columns I can imagine reasons.

Ok...I got that reason

but after 2005 its questionable

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-02-17 : 16:14:32

Agreed

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources