7 Replies Latest reply on Apr 3, 2013 5:07 AM by chiti

    Function returning query takes more time to run in Apex4.0

      Hi All,

      I created a report using function returning query. The function returns query based the parameters which returns dynamic columns. When I run the query in sql developer the query generates and returns the result in 3mins. But in apex it takes maximum of 35mins to return.

      The query will return around 10000 rows.

      Is it a performance issue in the query or in Apex?can anyone please help