Select * from table where ADEDATE = '23 June 2003' in SQLServer2000
This one works fine immediately.
2.Select * from table where convert(char(10),ADEDATE,121) =
This takes a lot of time and also the consumes the complete resources of the
I understand that first query is working fast as it based on index.When we
use CONVERT in 2nd query the execution time is more than 45 mins.
How to make the second query work fast?The table has 51 million records.
If we have to create indexes or whatever please mention in detail.