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

Home -> Community -> Usenet -> c.d.o.misc -> Re: good guess for final record number in SELECT?

Re: good guess for final record number in SELECT?

From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 26 Feb 2003 09:15:37 -0800
Message-ID: <1b061893.0302260915.49c6bd51@posting.google.com>


A good answer to your question depends significantly on the select statement being issued. If your tables and indexes have been analyzed recently (i.e. you use CBO), have you thought of using the data in user_tables (NUM_ROWS) and user_indexes (DISTINCT_KEYS)? This might allow you to at least get a high-level idea on the number of rows returned.

Daniel Received on Wed Feb 26 2003 - 11:15:37 CST

Original text of this message

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