SQLServerCentral / Discuss Content Posted by Christoffer Hedgate / Article Discussions / Article Discussions by Author / Cluster That Index - Part 2 / Latest Posts

RE: Cluster That Index - Part 2

DCPeterson — Tue, 14 Oct 2003 12:55:00 GMT

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.

RE: Cluster That Index - Part 2

Chris Hedgate — Fri, 10 Oct 2003 01:49:00 GMT

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

RE: Cluster That Index - Part 2

blaireau — Thu, 09 Oct 2003 12:50:00 GMT

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

RE: Cluster That Index - Part 2

Chris Hedgate — Wed, 08 Oct 2003 00:24:00 GMT

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 ([url]http://www.sqlservercentral.com/columnists/chedgate/clusterthatindexparttwo.asp[/url]). --Chris Hedgate @ Apptus Technologies (http://www.apptus.se)http://www.sql.nu

RE: Cluster That Index - Part 2

Chris Hedgate — Mon, 06 Oct 2003 01:19:00 GMT

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

RE: Cluster That Index - Part 2

ray_higdon — Sun, 05 Oct 2003 15:37:00 GMT

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

Cluster That Index - Part 2

Chris Hedgate — Sun, 05 Oct 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/chedgate/clusterthatindexpart2.asp