|
tpiazza55
Posting Yak Master
162 Posts |
 Posted - 11/01/2010 : 16:16:00
|
I have a query that has a lot of joins on it that searches millions of records.
the majority of the searches only look through the data of the last 5 days, occasionally all the data.
what i tried to do was make a query that searches through the last 5 days data, if no records search through the all the records.
what Im finding is that the query that searches through all the reocrds is a little faster than one searching through the records with the last 5 days of data.
same query -- only difference is the additional search through the last 5 days in the where clause.
what is a good way to speed this type of scenario up? |
|
query timeouts solution
