Index performance

From: Naren Chintala <naren_at_mink.att.com>
Date: 1996/10/28
Message-ID: <32750D74.7B02_at_mink.att.com>#1/1

Hi,

I hope someone can help me out here.

Scenario 1:

---

CREATE INDEX idx1 ON t1(c1,d1);
where c1 is varchar2
and d1 is a date field.

Scenario 2:

---

CREATE INDEX idx2 ON t2(n1,n2);
where n1 and n2 are numeric fields.

Question:

---

Please note that the concatenated index is a combination of different data types in scenario 1 and the data types are same in scenario 2.

Will a query (that uses the concatenated index) be faster in scenario 1 or scenario 2 or will be the same?

Oracle 7.2.3
Solaris 2.5

Thanks in advance for any pointers.
Please email your response also.

Naren Chintala
naren_at_mink.att.com Received on Mon Oct 28 1996 - 00:00:00 CET