Re: statement tuning ?

From: Tim Gorman <tim_at_sagelogix.com>
Date: Mon, 03 May 2004 12:18:08 -0600
Message-ID: <BCBBE900.143C7%tim@sagelogix.com>

If the column CUST_STAT_CD is indexed, then it would represent a potential method of quickly gaining access to the relevant rows in what is presumably a large table.

However, if the hard-coded value of "Active" is a popular data value (i.e. = a
large number of rows associated with the data value), then the method of using an index would not be very efficient. Indexes work best with unpopular data values (i.e. small number of rows associated with data value).

So, my recommendation implied that the poster should research about whether the value of "Active" was popular or unpopular. If it is an unpopular value, then it would make sense to see if an index would help. If it is a popular value, then the presence of an index would be a hindrance.

on 5/3/04 8:05 AM, David Green at thump_at_cosmiccooler.org wrote:

> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.=
org]
> On Behalf Of Tim Gorman

>=20
> 3. using the filtering/search predicate on the T11.CUST_STAT_CD column=
,
> which would work well if the column were indexed and the value of =93Active=
=94
> is relatively unpopular

>=20

> ---
> Tim,
> What do you mean here in suggestion number 3 please? I'm not clear...
> Thanks
> - David

>=20


> ----------------------------------------------------------------

> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon May 03 2004 - 13:15:55 CDT