Indexing Strategies

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 Ramesh Gummadi » Indexing Strategies

Indexing Strategies

Rate Topic

Display Mode

Topic Options

Author

Message

Ramesh Gummadi

Posted Sunday, December 28, 2003 12:00 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, February 01, 2013 2:13 PM
Points: 88, Visits: 64

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

Ramesh Gummadi

Post #19587

cppwiz

Posted Wednesday, January 07, 2004 7:24 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 28, 2013 11:21 AM
Points: 163, Visits: 357

Excellent article - well done !!!

Post #93874

bozo7

Posted Wednesday, January 07, 2004 7:49 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, March 15, 2007 9:22 AM
Points: 238, Visits: 1

Well done. Very informative.

Ross

Post #93881

pxdanie

Posted Wednesday, January 07, 2004 10:38 AM

Valued Member

Group: General Forum Members
Last Login: Monday, January 10, 2005 11:12 AM
Points: 63, Visits: 1

It's good, but somewhat inaccurate. In the first section about filtering on member_number, it says that the leaf level of the non-clusterd index has the row ID. This is true only if the table is a heap table (has no clusterd index on it). If the table does have a clustered index, the leaf level of the non-clustered index on member_nember constains the clustered key value, which is then used to do a clustered index seek to get to the actual data.

Post #93951

samm2425

Posted Wednesday, January 07, 2004 11:05 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, July 27, 2004 7:00 PM
Points: 99, Visits: 1

great article

very informative

Post #93954

Davidk

Posted Friday, January 07, 2005 2:49 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, September 18, 2008 1:13 AM
Points: 22, Visits: 3

I concur, very good article! Now all you need is an animated graphics design to walk through the process using the examples in b-tree format for visualization.

Post #154205

« Prev Topic | Next Topic »

Permissions