10g migration
Hi,
we are planning to migrate our application database from 9i to 10g. we are in testing process
we found one issue where in a form blind search in 10g is very slow comparing to that in 9i.
when we explore more into details we found below query execution plan is different between 9i and 10g
select * from table A order by column X desc;
Where X column is indexed.
Above query is doing index range scan in 9i, where as in 10g it's doing full table scan.
Do you know how to overcome this problem. any setting needs to do in the application environment to make my blind search is as fast as 9i.
thanks in advance..
--Ram