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

Cluster That Index - Part 2 Expand / Collapse
Author
Message
Posted Sunday, October 5, 2003 12:00 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Saturday, February 28, 2009 6:51 AM
Points: 1,489, Visits: 7
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/chedgate/clusterthatindexpart2.asp



--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/
Post #16966
Posted Sunday, October 5, 2003 3:37 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 28, 2004 8:04 AM
Points: 305, Visits: 1
Just read both of them, I am always amazed that there is always something new to learn about indexing. Excellent article, hesitant to trust that page splitting is so nominal (from first article) but have to do more testing.

Ray Higdon MCSE, MCDBA, CCNA



------------

Ray Higdon MCSE, MCDBA, CCNA
Post #82223
Posted Monday, October 6, 2003 1:19 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Saturday, February 28, 2009 6:51 AM
Points: 1,489, Visits: 7
quote:

Just read both of them, I am always amazed that there is always something new to learn about indexing. Excellent article, hesitant to trust that page splitting is so nominal (from first article) but have to do more testing.



Thanks Ray, glad that you liked them. If you do any testing on page splits please notify me with your findings.

--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
http://www.sql.nu




--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/
Post #82224
Posted Wednesday, October 8, 2003 12:24 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Saturday, February 28, 2009 6:51 AM
Points: 1,489, Visits: 7
About the title, "Cluster that index - part 2", it should have been either simply "Forward pointers" or maybe part 3 och Cluster that index, since there is already a part 2 (http://www.sqlservercentral.com/columnists/chedgate/clusterthatindexparttwo.asp).

--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
http://www.sql.nu




--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/
Post #82225
Posted Thursday, October 9, 2003 12:50 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 19, 2009 12:23 PM
Points: 4, Visits: 4
I got a question:

If a data page is split, there is a pointer added to the original page to point toward the new page (forward pointer like you just explained). If this new page is split again, is there another Forward pointer added to this page? This would mean that we are now at left with 3 pages?

Is there a way to set SQL to automatically removed this forward pointer? In a job maybe?

BTW good short and simple article.

Eric Blais



Eric Blais
Blaireau47@hotmail.com
Web Developper
Always looking for a challenge
Post #82226
Posted Friday, October 10, 2003 1:49 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Saturday, February 28, 2009 6:51 AM
Points: 1,489, Visits: 7
quote:

If a data page is split, there is a pointer added to the original page to point toward the new page (forward pointer like you just explained). If this new page is split again, is there another Forward pointer added to this page?



No, the original pointer would just be changed to point to the new location.

--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
http://www.sql.nu




--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/
Post #82227
Posted Tuesday, October 14, 2003 12:55 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, December 5, 2014 8:45 AM
Points: 1,035, Visits: 412
Good series of articles Chris. I especially appreciated that you got the "physical ordering" thing right. That is the source of much confusion, and if I were to make one recommendation it would be to emphasize the fact that clustered indexes do not maintain the physical ordering of data pages on disk.




/*****************

If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek



*****************/
Post #82228
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse