Home Forums SQL Server 2008 SQL Server Newbies How to set index for these select queries RE: How to set index for these select queries

  • January 17, 2013 at 9:28 pm

    #1578548

    GilaMonster (1/17/2013)

    Index on (IsDeleted, SubmitDate DESC) include (ProdName,Category,TotalStock,Price)

    What would be the exact sql query to create the index.

    btw, that's a rather odd predicate on the date column...

    how can you ellaborate ?