We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

General Discussions

Discuss any topics that are not product-specific here.

Alteryx WF Oracle DB performance issue

6 - Meteoroid

Hi,I have try to read the 20+ Million rows from Oracle Database and the Alteryx WF which running this SQL taking more than hour to finish it. When run the same SQL from Toad/Sql Developer its completed within 1 mins. Could you please suggest how can i improve the Alteryx WF performance when read the huge data from Oracle DB. 


For Data connection i have tried with Oracle OCI , ODBC & OLEDB , but none of them fixed the issue.

17 - Castor

Hi @Manikumarayyachamy 


Have you tried the Simba Oracle ODBC driver? Check out the solution to the below post for more details