Re: Oracle Query Tuning

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

You can see how Oracle resolves the select statement using the explain plan command. The access path shows you whether Oracle will use the index or not.

Holger Heidenbluth

--
KeepTool Software GbR   Home : http://www.keeptool.com
Schützalle 118          EMail: holger.heidenbluth_at_keeptool.com
D-14169 Berlin          Phone: +49-172-5272025