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: Wednesday, July 9, 2014 11:13 AM
Points: 65, Visits: 366
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: Monday, July 21, 2014 6:24 AM
Points: 2,451, Visits: 2,342
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: Yesterday @ 10:00 AM
Points: 1,711, Visits: 6,237
"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: Friday, July 11, 2014 1:50 AM
Points: 1,100, Visits: 4,897
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, July 3, 2014 2:45 AM
Points: 2,531, Visits: 536
"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
Post #831232
Posted Wednesday, December 9, 2009 3:29 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 4:53 AM
Points: 2,366, Visits: 1,844
"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: Thursday, July 10, 2014 7:24 AM
Points: 1,060, Visits: 874
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: Friday, July 11, 2014 2:38 AM
Points: 908, Visits: 202
This is false:
A clustered index physically rearanges data on disk.
Post #831291
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse