Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning On which column to create index if no where clause is present ? RE: On which column to create index if no where clause is present ?

  • November 18, 2013 at 3:21 am

    #1667062

    Shadab Shah (11/18/2013)

    Hi Experts,

    On which column should one create index if no WHERE clause is specified.

    example

    Select * from table_name

    No identity column is present on the table(because none is needed 🙂 ). I search this on major forum but i guess i may have got my keywords incorrect.

    Your example query is asking for ALL the columns and ALL the rows in your table. The only possible way to satisfy this query is to read ALL the pages. An index would not help you here.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]