Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: good guess for final record number in SELECT?
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