Skip to Content
Former Member
Sep 29, 2016 at 09:36 PM

Query slow via program but fast if executed in database


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.