how to reduce the cost of the query
Hi all,
we are processing one table data but i feel the fetching of records is pretty slow .when i checked the cost (explain plan for the below query)
query:
*********
select count(1) from XYX where policy_issue_date between '01-jan-2009' and '31-jan-2009'
and remarks is not null
explain plan:
***************
cost is 21,696
what i have to do to make the query much faster and efficient use of index ?
f.y.i
*** just now only i collected stats for that table and index is also rebuild and we have created the index on the column of
policy issue date column..
query:
*********
select count(1) from XYX where policy_issue_date between '01-jan-2009' and '31-jan-2009'
and remarks is not null
explain plan:
***************
cost is 21,696
what i have to do to make the query much faster and efficient use of index ?
f.y.i
*** just now only i collected stats for that table and index is also rebuild and we have created the index on the column of
policy issue date column..
0