Re: Oracle Query Tuning

From: InfoCardume <info_at_cardume.com>
Date: 1998/01/27
Message-ID: <6akomj$oai@snews3.newsguy.com>#1/1

If you would like to try our software (TunaSQL) for tuning SQL, you will find it useful. You can get an evaluation copy at www.dbesoftware.com

CardumeSoftware
www.cardume.com

manoj.lahoti_at_gepex.ge.com wrote in message <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 Tue Jan 27 1998 - 00:00:00 CST