RE: SQL Query tuning help

Thank you Stephane! Your final idea of FIRST_ROWS as a winner! Oracle slapped the data back in just a second. Thanks everyone for the ideas to try.   Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 10, 2002 3:4

RE: SQL Query tuning help

ist ORACLE-L > Subject: RE: SQL Query tuning help > > > Thanks everyone for your wonderful suggestions. And thanks > for leaving the > "hey stupid" off your reply header :-) > > Rachel - Thanks for the bitmapped idea. These tables don't > change

RE: SQL Query tuning help

Just in case anyone out there is interested, we use the term "Mickey Mouse schema" to refer to a very specific design tactic. We're *not* using the term's slang meaning of "unimportant" or "uninspired." (...Which always seemed odd to me, because MM is a really strong, high quality brand.) Specifi

RE: SQL Query tuning help

Thanks everyone for your wonderful suggestions. And thanks for leaving the "hey stupid" off your reply header :-) Rachel - Thanks for the bitmapped idea. These tables don't change often, so that may be a good alternative. Iain - Thanks so much for the detailed suggestions. Rick - Good sanity ch

RE: SQL Query tuning help

of list ORACLE-L Subject: SQL Query tuning help I am trying to tune a SQL query on Oracle 8.1.6. I have tried several optimizations, but so far have made no improvements. I would appreciate any suggestions. SELECT am.lid, am.name FROM am, so, sa WHERE so.lid = am.lid AND so.key_ = sa.so_k

Re: SQL Query tuning help

D]> cc: Subject: SQL Query tuning help I am trying to tune a SQL query on Oracle 8.1.6. I have tried several optimizations, but so far have made no improvements. I would appreciate any suggestions. SELECT am.lid, am.name FROM am, so, sa WHERE so.lid = am.lid AND so.key

Re: SQL Query tuning help

DENNIS WILLIAMS wrote: > > I am trying to tune a SQL query on Oracle 8.1.6. I have tried several > optimizations, but > so far have made no improvements. I would appreciate any suggestions. > > SELECT am.lid, am.name > FROM am, so, sa > WHERE so.lid = am.lid > AND so.key_ = sa.so_key > AND am.ac

RE: SQL Query tuning help

Dennis, If you use the ordered hint and have sa then so then am and also hint to use the index on sa(ret) then I think that would be about the best as you'd be starting with the best filter ie 1.3m/281 giving less than 5000 on average (assuming ret is indexed). I don't know if you'd have to thro

SQL Query tuning help

I am trying to tune a SQL query on Oracle 8.1.6. I have tried several optimizations, but so far have made no improvements. I would appreciate any suggestions. SELECT am.lid, am.name FROM am, so, sa WHERE so.lid = am.lid AND so.key_ = sa.so_key AND am.active = 1 AND so.code = 11 AND sa.ret = 'SB'