You should provide more data. But first you should gather statistics.

Older way:

analyze table AAA compute statistics;

will do, but it is better to use dbms_statistics. If your problem persist,
then serious approach to optimizing should be taken. Consider:
- indexes,
- size of table
- distribution of values in critical columns (histograms)
- your query
- whole execution plan data
...

KAzi


Shahed wrote:

>Hi gurus,
>
>I have migrated from 8i to 9i. There is a query which was quite faster in
>8i (1sec) but it became slow in 9i (1 min).
>I ran the explain plan. The position value is as follows
>in 8i Cost =1846
>in 9i Cost = 93241102
>
>pls suggest how to fix this issue
>
>Both have optimizzer_mode set to "choose".
>
>Regards,
>Shahed Baig . M
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>
>


Oracle LazyDBA home page