Secondary Index Concept

Database

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 ?

1 REPLY
Senior Apprentice

Re: Secondary Index Concept

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

2) All AMPs + FTS