Using indexes

[Former Member]

Hi experts,

I have a table with a created index ZIN (containing 4 fields).

If I want to use the index in the selection, what is the right statement?

[former_member182354]

Hi,

To use that Index write a Select statement with all the four fields available in the index in your where clause..

Raghav

[Former Member]

If I use 7 fields in the select statement, but it is including my 4 fields from the index, the system will automatically know that I want to use an index, am I right?

[former_member195383]

yes...it will automatically decide

[Former Member]

Yes.

[former_member195383]

u write the select query normally. using those four fields.

The utilisation of indexing will be done internally.

It will enhance the performance of ur select query

[Former Member]

Hi,

You have to use the fields that are specified in the Index into the where clause of your Select Query.

The sequence should be same.

Make sure your Index have MANDT field as well.

You can ignore this in the where condition though.

Thanks

Pranu

[Former Member]

Thanks for the replies.