Home Forums SQL Server 2008 SQL Server 2008 Administration Index Design RE: Index Design

  • August 24, 2012 at 4:04 am

    #1529630

    GilaMonster (8/24/2012)

    SQLSACT (8/24/2012)

    Am I missing anything here?

    Mainly that the pointer to the rest of the row is the clustered index key (if the base table is a clustered index). Not two separate things.

    Also, indexes (nonclustered) don't contain data rows, they contain index rows. Only the clustered index has data pages as the leaf level.

    http://www.sqlservercentral.com/articles/Indexing/68439/

    http://www.sqlservercentral.com/articles/Indexing/68563/

    http://www.sqlservercentral.com/articles/Indexing/68636/

    Thanks

    Help me understand something regarding the Leaf Level of the nonclustered Index

    Consider the following

    --Table

    create table test

    (Col1 int primary key clustered

    , Col2 int

    , Col3 int)

    --Index

    create nonclustered index NCX on test

    (Col3)

    --Query

    select Col3 from test where Col3 = '50'

    Would my select statement still have an interaction with the base table even though the nonclustered index satisfies the query completely?

    Thanks