Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: anyway to estimate number of rows in a query?

Re: anyway to estimate number of rows in a query?

From: Raj Jamadagni <rjamadagni_at_hotmail.com>
Date: 24 Dec 2003 04:56:45 -0800
Message-ID: <76772c3f.0312240456.79e1ba94@posting.google.com> 





You could use execute_immediate to 'explain plan for <sql_statement>',
then you could select plan_table.cardinality to get "approximate"
number of rows. Remember, it is an approximation and requires that you
know the sql statement to be executed   beforehand.



HTH



Raj
Received on Wed Dec 24 2003 - 06:56:45 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US