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 Feb 16 1998 - 00:00:00 CST
