Skip to Content
0
Former Member
Aug 01, 2008 at 03:25 PM

Secondary index - Considerations

9 Views

Hi,

I have to create a composite secondary index ( multiple fields ). What are the considerations in deciding the order of the fields in this index.

The where clause of the query will always use single value select for both these fields

eg : select F1 F2 from TAB where I1 = <X> and I2 = <Y>.

I1 and I2 are the fields that i want to index on.

Regards

Rajesh