topic Problem with table index in Application Development and Automation Discussions

Problem with table index

Former Member — Thu, 22 Jan 2009 14:57:37 GMT

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

Re: Problem with table index

Former Member — Thu, 22 Jan 2009 15:04:43 GMT

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

Re: Problem with table index

Former Member — Thu, 22 Jan 2009 15:07:16 GMT

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

Re: Problem with table index

Former Member — Thu, 22 Jan 2009 15:39:19 GMT

Can you post the queries and their execution plans?