Oracle Tuning

[kal...@gmail.com]

Hi,

I am running one query which is taking so much time. I would like to
know how to
increase the performance of the query..

Thanks,
Kala

[evanb...@gmail.com]

can u show me ur query...leave it

checks the following steps..
1.checks whether ur query going full or rows scan
2.if full tables scan(create index for the particular field)
3.analyze index <index name> validate structure;
4.checks the deleted entries from index_stats views
5.alter that problem is not solved
6.rebuild the index
and then trace ur query
7if not solve
8.fine out row chaning and migration(using utlchain.sql) if row
chaining occurs just export the table and drop the table and then
import or move table to another tablespace
i think its enough............