title: Performance is poor of pipelined function in SQL Developer
body: <p>I have a pipelined table function like</p>
  
  <pre><code>FUNCTION FOO
  (
      &lt;PARAMETERS_LIST&gt;
  ) RETURN T_TAB PIPELINED
  AS
  BEGIN
  FOR rec IN
  (&lt;A LITTLE BIT COMPLEX QUERY WITH PARAMETERS_LIST&gt;)
    LOOP
      PIPE row(T_WF(&lt;COLUMN_LIST&gt;));
    END LOOP;
    RETURN;
  END FOO;
  </code></pre>
  
  <p>I test the query in SQL Developer via <code>select * from TABLE(FOO(&lt;PARAMETERS_LIST&gt;)) WHERE ROWNUM &lt;= 200</code>. It takes SQL Developer 9 seconds to return data.</p>
  
  <p>While it take 0.9 seconds to result when running <code>&lt;A LITTLE BIT COMPLEX QUERY WITH PARAMETERS_LIST&gt;</code> directly in SQL Developer.</p>
  
  <p>Why is the pipelined function so slow?</p>