Chase it with a big stick
Nah just kidding
Provide some more detail like version and what you are trying to actually
do and you are going to get a better answer.
As I always understood it, to get the best performance all other things
being correct with the system is that you have to make your query use
indexes. Avoid the commands that cause full table scans and determine the
best structure. for example to find all the customers with the surname
Simple in the states of Utah, Texas and Kansas make your query work so that
it firstly pulls the smallest data set and searches that data set.
This concept would only apply if you data had a many more clients from
those three states than clients named Simple.
I would find all the Simples and then check there state rather then the
other way around
HTH
Peter
At 04:00 AM 29/05/2001 -0800, you wrote:
>Hallo you DBAs;
>
>How can I make a query run faster, I have some queries and they tend to be
>be very slow.
>
>Roland Sk�ldblom
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Peter McLarty
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
