All Forums Database
bibhu23 1 post Joined 07/15
04 May 2016
Secondary Index Concept

Hi,
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 ?

dnoeth 4628 posts Joined 11/04
04 May 2016

1) There's only one PI per table, but sometimes you want/need to index more than one column :)
2) All AMPs + FTS

Dieter

You must sign in to leave a comment.