Re: Performance problem.

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Mon, 29 Aug 2005 15:01:08 GMT
Message-ID: <Xns96C1519CB6EA3SunnySD@68.6.19.6>

"Patrick" <p_mokry_at_ifrance.com> wrote in news:43131ddc$0$26084$626a14ce_at_news.free.fr:

> Hi everybody.
>
> 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.
>
>
>

Use SQL_TRACE & EXPLAIN_PLAN then post the results here. Received on Mon Aug 29 2005 - 10:01:08 CDT