Re: Oracle Query Tuning

From: Pei L. Ku <pku_at_gte.net>
Date: 1998/01/19
Message-ID: <69usl1$ms7$3@gte2.gte.net>#1/1

I'd recommend to you to familiarized yourself with tkprof and explain plan. These are valuable tools in determining resource consumption and execution plan of your SQLs. If you are running on SMP machines, look into Parallel Query features.

Pei

manoj.lahoti_at_gepex.ge.com wrote in article <885079291.2007040019_at_dejanews.com>...
> 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
>
Received on Mon Jan 19 1998 - 00:00:00 CST