Question on table indexing

[Former Member]

Hi all experts,

Assuming we have indexing for fields F1,F2,F3,F4 and F5 as INDEX_1 for a table in order to use for SELECT statement, but there is another SELECT statement which only use F1,F2, F4 and F5. If this is the case, will the indexing INDEX_1 applicable?

Or I should create a new indexing INDEX_2 for F1,F2, F4 and F5?

Anyone has tested the performance before? Please advise.

Your input are greatly appreciated.

[Former Member]

Hi

Answer for your question is No not required but again clauses added. Please go through this nice explanation from Hermann in the thread , you'll understand how the indexes work exactly.

Regards

Ranganath

[Former Member]

Hi,

I think the index will not be triggered but again it is not necessary the fields are in the same order in the where clause as they are in the index. The program will take care of it and can check if the required fields are there in the index or not irrespective of whether they are in the order or not.

Guru.

[Former Member]

Hi Wong,

The Select statement will infact use the index INDEX_1 even if you miss a field F3 (but not as effective as you give all keys).

It will not be possible for us to suggest creating an index or not. It depends on how important or critical this data selection is and how worse it is affecting the performance.

You can do a trace in ST05 and check yourself. If the select seems too expensive, then you can create another index with F3 included.

//Kothand