Home Forums SQL Server 2008 SQL Server 2008 Administration Ask for help in index RE: Ask for help in index

  • December 26, 2012 at 6:44 am

    #1571553

    Adi Cohn-120898 (12/26/2012)

    When SQL Server has to read very small tables, it many times uses table scan. In such small size, it doesn't make a difference.

    Adi

    Sir,

    If large table, the index scan will change into index seek?