Re: Oracle Query Tuning

From: <denny_vk_at_hotmail.com>
Date: 1998/02/18
Message-ID: <6ceht9$46a$1@nnrp1.dejanews.com>#1/1

Hi,

I would like to know the version of Oracle you are using. If you are using Oracle 7.3 or above bit mapped indexes may help. Also the performance would depend on the controlling table and also the position of the columns in the where clause.

Denny

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, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Feb 18 1998 - 00:00:00 CST