Index question

From: Rick Stephenson <RStephenson_at_Ovid.com>
Date: Tue, 10 Aug 2004 09:08:42 -0600
Message-ID: <555F2B7B278B5348A28F665E6B0E43A40935EA2E@exchange-slc.ut.ovid.com>

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_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 - 10:04:32 CDT