MDAM on index

[Liu, Ming (Ming)]

Hi, all,

If we are creating a table t(c1,c2,c3,c4,,c5, primary key(c1,c2)) and then 
create an index indx on t(c3,c4).
Query 1: select * from t where c2 =10;
Query 2: select * from t where c4 = 10;
I think Query 1 will use MDAM, can Query 2 use MDAM to access indx as well?

Thanks,
Ming