clustered vs Non clustered index scan

  • Thank you Ninja's_RGR'us for the tip about saving the plan as .sqlplan. Now I can see it.

    While there is no filter on the date column I am just wondering if one could be added. Depends on the situation, but sometimes old data is not relevant to the user and it might lower the row count. Just a thought.

Viewing post 16 (of 15 total)

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