topic Re: Using indexes in Application Development and Automation Discussions

Using indexes

Former Member — Wed, 23 Jul 2008 07:14:19 GMT

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?

Re: Using indexes

former_member182354 — Wed, 23 Jul 2008 07:17:07 GMT

Hi,

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

Raghav

Re: Using indexes

former_member195383 — Wed, 23 Jul 2008 07:18:11 GMT

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

Re: Using indexes

Former Member — Wed, 23 Jul 2008 07:18:26 GMT

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

Re: Using indexes

Former Member — Wed, 23 Jul 2008 07:20:46 GMT

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?

Re: Using indexes

former_member195383 — Wed, 23 Jul 2008 07:21:51 GMT

yes...it will automatically decide

Re: Using indexes

Former Member — Wed, 23 Jul 2008 07:23:04 GMT

Yes.

Re: Using indexes

Former Member — Wed, 23 Jul 2008 07:23:46 GMT

Thanks for the replies.