Re: Composite index question

On Sat, 13 Apr 2002 18:51:36 GMT, "Tintin" <nospam_at_nospam.com> wrote:

This was certainly a bigger issue previous to 9i. You still may wish to consider cardinality if you use index compression.

In 9i, IIRC, it is called Skip Scan Indexing or something similar.

In a recent copy of oramag at oramag.com there was discussion on this.

>Learning Oracle 9i. Need some clarification on something.
>
>If I create a composite index on columns A, B and C and want to run a SELECT
>query that uses that index, do I have to specify the columns in the WHERE
>clause in the same order they are in the index?
>
>~ !T
>
>
Received on Sat Apr 13 2002 - 18:31:07 CDT