Re: good guess for final record number in SELECT?

danielroy10_at_hotmail.com (Daniel Roy) writes:

> 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.

Using user_tables and user_indexes is an interesting idea, but the result tables will be a small sub set of some huge tables which are restricted by some WHERE clauses.

But, thank you it is somthing to think about.

Volker

-- 
Volker Apelt