Re: Index performance

Naren Chintala wrote:
>
> 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

1. use TKPROF and Examine the resaults after running two querys.
2. It looks like phase 2 will be faster.

Asaf shoval. Received on Fri Nov 08 1996 - 00:00:00 CET