Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Best way to select a large amount of data? RE: Best way to select a large amount of data?
ricardo_chicas
SSCertifiable
Points: 5024
More actions
August 19, 2010 at 2:11 pm
#1209359
Hi,
I forgot to say that the "like" is this way: column like '123456%'
so it is using the index and doing a clustered index seek