Cluster That Index

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Christoffer Hedgate... » Cluster That Index - Part 2

Cluster That Index - Part 2

Rate Topic

Display Mode

Topic Options

Author

Message

Chris Hedgate

Posted Sunday, October 05, 2003 12:00 AM

UDP 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

ray_higdon

Posted Sunday, October 05, 2003 3:37 PM

Old 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

Chris Hedgate

Posted Monday, October 06, 2003 1:19 AM

UDP 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

Chris Hedgate

Posted Wednesday, October 08, 2003 12:24 AM

UDP 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

blaireau

Posted Thursday, October 09, 2003 12:50 PM

Forum 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

Chris Hedgate

Posted Friday, October 10, 2003 1:49 AM

UDP 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

DCPeterson

Posted Tuesday, October 14, 2003 12:55 PM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 8:38 AM
Points: 1,032, Visits: 390

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 »

Permissions