Simple SQL statement help request...

  • The test results I stated above reflect the use of a NON-clustered index on the date_field.  I have retested with a Clustered index on the date_field  and when selecting all columns, the cost of the first statement relative to the batch shows 10% while the second statement is 90%.

     

Viewing post 16 (of 15 total)

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