Posted on Feb 18, 2015 Performance SQL ServerMove from Scan to Seek As a SQL optimization best practice, Scans are bad, Seeks are good. Sachin Dhirclusteredindexscanseek