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

    Slow Extract

    fauziajalali.jalali
    fauziajalali.jalali Feb 22, 2016 4:15 PM

      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
          Andrew Macey Feb 22, 2016 5:38 PM (in response to fauziajalali.jalali)

          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
            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!