Re: Help with a SQL statement

If (and it's a big if) all of the tables are analyzed, then a query to dba_tables will return the row_count and the table_name and owner (with much more). This is information that the cost based optimizer uses.

James

In article <6tmeqi$l5k$1_at_nnrp1.dejanews.com>, stuco_at_mailcity.com wrote:

>I would like to issue one SQL or PL/SQL statement that would gather
>table_names and their respective row counts. How can this be done?? I know
>that I can write a SQL statement to create a bunch of SQL calls, but I would
>rather only make one call to the database to save on overhead.
>
>thanks ever so much!
>
>Stuart Cowen
>Paladin Consulting - Dallas
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

-- 
lorenzen_at_tiny.net             | Life is complex; it has
                              |   real and imaginary parts