Secondary Index and Joins

Database
Enthusiast

Secondary Index and Joins

Hi,

Can anyone please explain if Secondary Indices provide any help in performance when the SI columns are used in a Join condition ? I believe they only help the performance when used in residual conditions such as WHERE clause ?

Thanks

1 REPLY
Junior Supporter

Re: Secondary Index and Joins

Hi.

The optimizer will use NUSIs in "covering query situations" when possible.

Cheers.

Carlos.