Re: Performance problem.

Patrick wrote:

> I know that there is a lot of way to increase performance of an application.
> But could you tell me some I could not think of ?
> I'm a totally lame on that part.
> I have a big query, searching results trougth 12/15 tables, the time cost of
> that is 20seconds.
> The query is good, i could not make it better.
> I made some indexes, maybe they are not totally appropriated, maybe not.
> Could you help me by giving me a web site or some tips or what to look for ?
>
> Thanks a lot.
> Patrick.

LOL. It is the rare query indeed that can not be made better.

What version and edition of Oracle?
Running on what hardware platform and operating system? What DDL and DML?
Where is the explain plan?
What are the tuning parameters?
How current are optimizer statistics?
What type of indexes for what cardinality?

Start anywhere you wish. ;-)

HTH

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)