7 Replies Latest reply: Apr 3, 2013 12:07 AM by chiti RSS

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

    chiti
      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

      Regards
      Raj