Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Tuning Question
In article <391D730D.3178_at_btinternet.com>,
High.Flight_at_btinternet.com wrote:
> How much money / use-of-resources is going to be saved making a 10
> second query run any faster?
>
> More than the cost your time tuning it??
>
> I think this is the real question.
>
> David P.
>
> Oracle Certified DBA.
>
RS, David is right. There is no point wasting time tuning a 10 second
query providing it is not part of a loop or the slow point in an
unsatisfactory performing screen. Full tables scan are not bad, in and
of themselves. It is the reason that the full scan is being done that
is most important. In this case there is not other way to retrive the
data without making some data/application changes.
-- Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice -- Sent via Deja.com http://www.deja.com/ Before you buy.Received on Mon May 15 2000 - 00:00:00 CDT