Post reply

Create new index direct advantages?

  • August 21, 2009 at 7:46 am

    #133117

    When you create an index. Does the benefit of the index take in effect directly?

    OR

    Does the index needs to be indexed first, which happen when the database/table/new index is used?

  • August 21, 2009 at 7:48 am

    #1042833

    i dont think an index can be indexed. When you query a table having index and the where clause contains a column on which index is built, the index is used in the execution plan.


    Pradeep Singh

  • August 21, 2009 at 8:02 am

    #1042845

    When an index is created queries queries can use it immediately.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply