Re: Oracle Query Tuning

Hi,

The best thing to do is playing around with the SQL to select the same records with different SQL statements and to check the execution plan of Oracle for each query. You might discover what is wrong with your queries.

You can use the explain plan utility to do that.

I have created an Oracle Form which makes playing around with this very easy. I generates the execution plan for a SQL statement you specify. It also gives information about the individual operations in the generated plans.

Have a look at http://members.aol.com/gjlinker I have called the form Explain.

Thanks, Gerrit-Jan Linker

In article <885079291.2007040019_at_dejanews.com>,   manoj.lahoti_at_gepex.ge.com wrote:
>
> I'm trying run a select query against 3 oracle tables with 250,000 ,45000
> and 5000 records respectively. I have indexes on almost all the fields
> that i'm using in where clause of the query. Now this query took about 30
> min to fetch the results when I tried to create index on a field which
> has only 2 values i.e. 'Y' and 'N, otherwise it takes about 10 -15 min to
> run this query. Any suggestions to improve the query response would be
> appreciated.
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet