This content has been marked as final.
Show 2 replies
-
1. Re: Slow Extract
Andrew Macey Feb 22, 2016 5:38 PM (in response to fauziajalali.jalali)1 of 1 people found this helpfulBy saying sql developer, I assume you mean the database is Oracle. Most desktop tools that I've used do array fetches, and don't fetch the whole resultset initially. If your Oracle query is using FIRST_ROWS optimizer target, then Oracle will start returning rows as soon as hits are found, even though it is still running on the DB. By contrast, Tableau extract cant complete until all rows are returned. Try running select count(*) from (<your-query-goes-here>) in SQL Developer to see how long it takes. If it takes a long time to run, your 15sec test case is meaningless.
-
2. Re: Slow Extract
fauziajalali.jalali Feb 23, 2016 6:49 PM (in response to Andrew Macey)Thanks Andrew for your response. You are right, it does take 14 min to run in Oracle sql developer. Would you have any suggestions to optimize this query? Thanks!