Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Clustered Index Internals Expand / Collapse
Author
Message
Posted Tuesday, December 8, 2009 9:49 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 7:16 PM
Points: 69, Visits: 382
Comments posted to this topic are about the item Clustered Index Internals
Post #831157
Posted Wednesday, December 9, 2009 12:43 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, May 9, 2014 12:47 AM
Points: 3,448, Visits: 4,407
Terribly phrased options to choose.
A clustered index physically rearanges data on disk.

rearranges?
I think this option should look like this: "When created or rebuilded, a clustered index physically rearranges data on disk".
A quote from the explanation (and from the Delaney's book):
Once created, a clustered index is maintained logically rather than physically.
...
After that (after creation), maintaining the clustered index is a logical operation.


Another option from the question:
Dropping a rebuilding a clustered index on a partition scheme will move disk to other drives.

Maybe, "Dropping and rebuilding"?
"Move disk to other drives" – what is the meaning of this? Sounds like abracadabra for me
Maybe, it means "moving logical disks C:, D:, E: to other hard disk drives"?
Post #831200
Posted Wednesday, December 9, 2009 1:14 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:53 AM
Points: 2,618, Visits: 2,466
vk-kirov, I agree with you. Question and answer is incomprehensible!!!!
Post #831205
Posted Wednesday, December 9, 2009 2:19 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 9:24 AM
Points: 1,827, Visits: 6,639
"Dropping a rebuilding a clustered index on a partition scheme will move disk to other drives."

I have no idea what this means, and the answer doesn't seem to mention it.

Can someone explain please?!
Post #831219
Posted Wednesday, December 9, 2009 2:40 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 5:26 AM
Points: 1,120, Visits: 4,909
This reminded me of something that has been puzzling me recently about clustered indexes. If the leaf level of a clustered index actually is the table's data itself, does this mean the table data only exists in the index, or is there another copy somewhere else?
e.g. if a table without a clustered index has one created, does all the table data get copied into the leaf level of the clustered index, or does it get 'moved'.
Post #831225
Posted Wednesday, December 9, 2009 2:49 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 11, 2014 6:27 AM
Points: 2,624, Visits: 583
"Dropping a rebuilding a clustered index on a partition scheme will move disk to other drives."

Are you serious? What if I only have one disk (physical or logical (like in a SAN))? Where will it move? To Limbo or what?

I would say that the answer is wrong, becuase data will only be moved to other drives if the partition scheme uses a File group that is placed on another drive.


/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
Post #831232
Posted Wednesday, December 9, 2009 3:29 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:08 AM
Points: 2,365, Visits: 1,846
"Dropping a rebuilding a clustered index on a partition scheme will move disk to other drives." - Very confusing.

"Keep Trying"
Post #831256
Posted Wednesday, December 9, 2009 3:38 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, January 11, 2013 12:41 PM
Points: 621, Visits: 297
the options where bit confusing



Bhavesh Patel

http://bhaveshgpatel.wordpress.com/
Post #831260
Posted Wednesday, December 9, 2009 3:55 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 2:51 AM
Points: 1,070, Visits: 912
This last answer would make perfect sense if it was phrased as 'May' instead of 'Will'.

Poorly worded question - especially given how many of the questions on here are irritatingly pernickety about this type of pedantic points.



Post #831275
Posted Wednesday, December 9, 2009 4:43 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 8:38 AM
Points: 937, Visits: 235
This is false:
A clustered index physically rearanges data on disk.
Post #831291
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse