Hello,

>> Given an index:
>>
>> CREATE ASC INDEX IDX_A ON TABLE_A (COL_1, COL_2, COL_3);
>>
>> Which portions of the index will the following query use?
>
> COL_1 and COL_2.

the query was:
SELECT 1
FROM TABLE_A
WHERE COL_1 = ? AND COL_2 > 0 AND COL_3 = ?

why not on col_3?

Regards.,
...michal