Re: Slow query

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: Roland.Skoldblom_at_ica.se
>
>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: ListGuru_at_fatcity.com (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: peter.mclarty_at_incts.com

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: ListGuru_at_fatcity.com (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).