RE: Index question

is this a range scan or an equality search?
for equality searches, the difference will be minimal --
but range scans will be more expensive. 
how much? that depends...

is the performance "good enough"? then leave it as is!

Kind regards,
Lex.
 
---------------------------------------------
visit my website at http://www.naturaljoin.nl <http://www.naturaljoin.nl> 
---------------------------------------------
 


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Rick Stephenson
Sent: Tuesday, August 10, 2004 16:09
To: Oracle ListServ (oracle-l@xxxxxxxxxxxxx)
Subject: Index question


I have a query that references Table t column c in the where clause.  Table
t already has an index on (column c, column d).  Is there any reason to add
an index to table t that contains just column c?  I know that Oracle will
use the other index because of the leading column, but is there a
performance hit due to it being a composite index?
 

I am running Oracle EE 9.2.0.5.

 

Thanks,

 

Rick Stephenson

 



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------


-- Binary/unsupported file stripped by Ecartis --
-- Type: text/x-vcard
-- File: Lex de Haan.vcf


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: