Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Index question

RE: Index question

From: <Jared.Still_at_radisys.com>
Date: Tue, 10 Aug 2004 11:29:45 -0700
Message-ID: <OF5DDBF80A.EC9F66B6-ON88256EEC.00656F27-88256EEC.00659CB2@radisys.com>


> Thanks for your help on this. The additional column is a varchar2(32)
data
> type. I ran some tests too see the effect on the number of blocks
retrieved
> to satisfy a query. The single column required 360 blocks, whereas the
> concatenated column required 369 blocks. Not much difference, but I
guess
> it all depends on the performance requirement of the application.
>
> Thanks,
>
> Rick Stephenson
>

I wouldn't think that a 2.5% decrease in the number of index blocks read would justify another index. The 2.5% difference translates to a smaller overall change in response time, particurlary if the query must also read table blocks. ie. the index alone cannot satisfy the query.

Jared



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 Tue Aug 10 2004 - 13:28:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US