Let me rephrase my question, a bunch of trees were blocking the view of
the forest.

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? Just COL_1,
or all three columns?

SELECT 1
FROM TABLE_A
WHERE COL_1 = ? AND COL_2 > 0 AND COL_3 = ?

Thanks, Rick DeBay