March 3, 2011 at 2:45 am
hi,
I am having table which contains more than 5,00,000 records. Using where condition i retreive the wanted records.But , I used five columns in where conditons .All the five columns are indexed columns. while executing query, Its take long time of execution... I know ,because of Indexed columns , its take long time of excution..How to reduce the execution time for that query....
March 3, 2011 at 3:04 am
Please see this post (http://www.sqlservercentral.com/articles/SQLServerCentral/66909/ ) for how best to help us to help you
March 3, 2011 at 5:46 am
brainblower13 (3/3/2011)
I know ,because of Indexed columns , its take long time of execution.
why you think so ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply