IG sql very slow

User_TSP00

The APex screen is very slow fetching data. The same sql works like a charm in Toad, Forms Builder etc. but it is just slow in APEX.

Any tips or suggestions on how to speed the results?

B_Brock

This APEX Instant Tips video from Insum may be useful to you:

https://www.youtube.com/watch?v=fNO4qwvDReM&list=PLCAYBJ7ynpQQQrdwKFBZu8Kx9VTFt-pRP

InoL

The same sql works like a charm in Toad

It's very likely not the same query. When running in TOAD developers often forget:

• Select list columns in the IG need to get the display value from the LOV query.
• An IG may have non-query columns added.
• An IG may have Page X - Y of Z pagination. Your query doesn't calculate Z.
• An IG can have an Order By that is not in your query.