Problem with table index

[Former Member]

Hi!

We created an index for Z table but the ABAP program trace (using transaction ST05) for this table shows us that there is no access by this index. However, the same query in Oracle accesses the table by the index we created.

Any ideas of what happen here?

Thanks!!!!

Cristian

[Former Member]

Hi!

We created an index for Z table but the ABAP program trace (using transaction ST05) for this table shows us that there is no access by this index. However, the same query in Oracle accesses the table by the index we created.

Any ideas of what happen here?

Thanks!!!!

Cristian

[Former Member]

Hi ,

The index to be used is determined by the system during the program execution , in case you want the system to use a perticular index , then you will have to use Oracel Hints in the select statement , where you specify the index you want the system to use during data selection.

Please see the post which gives an example , Or[Oracle Hints [Specify Index ]|;

Regards

Arun

[Former Member]

So it must be in two completely different systems - right?

Make sure the statistics are up to date in the system where it is not using the index.

Rob

[Former Member]

Can you post the queries and their execution plans?