______SQL & Index Question

Hi,

say I have a table with many columns and 100.000 rows. Table is also partitioned in 10 pieces according to the values in Column C:

    Column B has 70.000 different values     Column C has 10 different values.

I'll query the table always giving two arguments for B and C.

How should I index this table:

1. local index on (B,C)
2. local index on (C,B) (What's the difference between 1 and 2 ?)
3. global index on B
4. local index on C
5. none of them, but...

I'd appreciate any ideas.

--
Thanks in advance

Emre AKBAG

akbag_at_scr.siemens.com
Siemens Corporate Research