I have a table with 200,000 records.
it has five fields:
it is used to monitor searches on multiple websites.
I want to return all the terms in a single query and have them presented in a table, ALL 200,000 records.
It works but it takes an absolute age, about 1min20sec
I'm not an expert in sql, but the query i have to retrieve the records is:
Select * From tblSearch Where tblSearch.strDate Like '" & strQueryDate & "'"
Is there any way of speeding this up? i looked at indexes and created one on strDate but i'm not sure if it did anything. my explain looks like:
select type: simple
extra: using where
all other fieilds are empty.
thanks for any help guys