View Single Post
  #2  
Old 8th December 2005, 21:38
dave_23's Avatar
dave_23 dave_23 is offline
Guru
 
Join Date: Oct 2002
Location: Portland, OR
Posts: 1,303
dave_23 will become famous soon enough
Baan: All - DB: Oracle / MS SQL / DB2 - OS: All
It looks like you're looking at dba_tables/user_tables to determine
# of rows..

do
select count(*) from <tablename>;

to see if they are really there.. if they are, then just run
analyze table <tablename> estimate statistics;

Dave
Reply With Quote