i have two Qus
1 ) In which scnario i will use Secondary Index why not Primary Index?
2)select * from EMP_TAB -> which type of AMP operation 2 AMP,All AMP or FTS ?
1) There's only one PI per table, but sometimes you want/need to index more than one column :)
2) All AMPs + FTS