Re: Help me to get fast query
Hello,
it would be helpful if you showed us a structure of tables, indexes and an explain plan.
Just execute:
show create table table_name
show index from table_name
for each table name used in your query,
and also:
explain your_query_goes_here
and post output of these commands.
Subject
Written By
Posted
Re: Help me to get fast query
January 08, 2012 09:20AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.