functions like year() and month() forces index scans or worst, clustered index scan. My method allows for a seek. You can't imagine the performance gain on a huge table.
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply