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

Indexing Strategies Expand / Collapse
Author
Message
Posted Sunday, December 28, 2003 12:00 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, July 14, 2013 8:09 AM
Points: 88, Visits: 66
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rgummadi/indexingstrategies.asp


Ramesh Gummadi
Post #19587
Posted Wednesday, January 07, 2004 7:24 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 06, 2014 3:47 PM
Points: 164, Visits: 368
Excellent article - well done !!!


Post #93874
Posted Wednesday, January 07, 2004 7:49 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC 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
Posted Wednesday, January 07, 2004 10:38 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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
Posted Wednesday, January 07, 2004 11:05 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

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

great article

very informative




Post #93954
Posted Friday, January 07, 2005 2:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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 »

Add to briefcase

Permissions Expand / Collapse