clustered index

Question

clustered index

Viewing 4 posts - 31 through 33 (of 33 total)

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

Hemanth Ramesh SSC Enthusiast Points: 128 More actions · Answer 1

I still don't get how there can be multiple clustered indexes on the same table in DB2. Once the data is physically sorted based on one column, the other indexes are simply going point to that location.

vinu.kutty86 SSC Veteran Points: 243 More actions · Answer 2

For Clustered Index,Data and index are stored in same place.ie., it stores logically with the table data.So that we have only one clustered index for a table.An index may compriese more than one column which is known as Composite Index.

For Non-Clustered Index , Data and Index are stored in different place.Here we can have 249 Non Clustered (2005) and 999 Non clustered(2008)for a single table

:discuss:[font="Comic Sans MS"]Vinu....
I’ll always be the first casualty of your database failure.[/font]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Please note: 2-year old thread.

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

Manoj Sahoo SSC Rookie Points: 47 More actions · Answer 4

Because we can have only one Primary key in a table