APEX

Hi experts,

I'm using Apex 18.2 and I have a page with an IR that executes an SQL against another remote Oracle database via db-link.

Query ran in SQLDev (with exact same value in the bind variables) expends 8 seconds in return 6000 rows

Same query ran in Apex expends almost a minute to draw the first 50 rows.

Already changed IR properties that may be related:

Pagination Type changed from

"Row Ranges X to Y of Z"

to

"Row Ranges X to Y"

Also changed "Maximum Rows to Process" from 1000000 to null.

Any other suggestion?

Thanks,
Jose.