title: Order By clause causing Performance Hit
body: <p>I've a SQL query that uses pipelined table function as below.</p>
  
  <pre><code>select col1,col2,... col75 from table(pipelinedtablefunction) 
  order by col1
  </code></pre>
  
  <p>This query returns 100 000 records in 14 mins. If I remove the order by clause and execute the below query, the query runs in 1 second and retrieves same result.</p>
  
  <pre><code>select col1,col2,... col75 from table(pipelinedtablefunction) 
  </code></pre>
  
  <p>I used order by clause inside pipelined function in the cursor query and I faced the same problem. Is there any way to resolve and improve the performance?</p>