2 Replies Latest reply on Feb 23, 2016 6:49 PM by fauziajalali.jalali

    Slow Extract

    fauziajalali.jalali

      Hi All,

       

      My extract is taking over 2 hours to load in desktop Tableau(9.1). Same Query takes 15 sec to run in sql Developer. Any ideas what could be wrong?

       

      Thanks!

       

      Zia

        • 1. Re: Slow Extract
          Andrew Macey

          By 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.

          1 of 1 people found this helpful
          • 2. Re: Slow Extract
            fauziajalali.jalali

            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!