RE: help in making the query to use the index

e; which is not overriding the expenditure column. Still my query goes for the full table scan. With regards kamesh jayachandran Get your FREE web-based e-mail and newsgroup access at: http://MailAndNews.com Create a new ma

help in making the query to use the index

--+ 1 row in set (0.06 sec) I don't know why the query goes for the full table scan.(As the total no.of rows that satisfy the where condition(date) is less that 30% of the total number of records. Can anyone enlighten me in making the qu