SQLServerCentral / Discuss Content Posted by Ramesh Gummadi / Article Discussions / Article Discussions by Author / Indexing Strategies / Latest Posts

RE: Indexing Strategies

Davidk — Fri, 07 Jan 2005 02:49:00 GMT

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.

RE: Indexing Strategies

samm2425 — Wed, 07 Jan 2004 11:05:00 GMT

great article

very informative

RE: Indexing Strategies

pxdanie — Wed, 07 Jan 2004 10:38:00 GMT

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.

RE: Indexing Strategies

bozo7 — Wed, 07 Jan 2004 07:49:00 GMT

Well done. Very informative.

Ross

RE: Indexing Strategies

cppwiz — Wed, 07 Jan 2004 07:24:00 GMT

Excellent article - well done !!!

Indexing Strategies

Ramesh Gummadi — Sun, 28 Dec 2003 00:00:00 GMT

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