Re:Oracle Query Tuning

From: Vinay Joshi <vjoshi_at_pinnacle.co.uk>
Date: 1998/01/18
Message-ID: <717BDE76D864D011870F00A0C9283F1E0FE50C@exchange.pinnacle.co.uk>#1/1

Unless you specify the actual query, the hints and oracle version information, it is very difficult to give you a proper answer.

Oracle DBA/Support
Vinay Joshi
Pinnacle Insurance Plc

> -----Original Message-----
> From: manoj.lahoti_at_gepex.ge.com [SMTP:manoj.lahoti_at_gepex.ge.com]
> Posted At: 17 January 1998 23:41
> Posted To: server
> Conversation: Oracle Query Tuning
> Subject: Oracle Query Tuning
>
> 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 Sun Jan 18 1998 - 00:00:00 CST