Query slow via program but fast if executed in database

[Former Member]

We are facing a strange issue.

We have 2 custom fields in standard table and the select query has these in the Where clause.

The index is created , activated and adjusted on these 2 fields via SE14.

The query called from function module in quality runs in fraction of milli seconds.

In production it takes 90 seconds.

When we run the query directly in oracle (And also SE16) , it takes fraction of seconds .

I am trying to figure out why the program behaves differently.

[Former Member]

We are facing a strange issue.

We have 2 custom fields in standard table and the select query has these in the Where clause.

The index is created , activated and adjusted on these 2 fields via SE14.

The query called from function module in quality runs in fraction of milli seconds.

In production it takes 90 seconds.

When we run the query directly in oracle (And also SE16) , it takes fraction of seconds .

I am trying to figure out why the program behaves differently.

[Sandra_Rossi]

For all questions about database query performance, you have to run the SQL trace (transaction ST05), and analyze the execution plan. It may be analyzed by a database administrator.