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: Select count(*)

Re: Select count(*)

From: G.C. (Jerry) Horel <jhorel_at_email.msn.com>
Date: 1997/12/03
Message-ID: <665d55$avs$1@thefuture.qualcomm.com>#1/1 







The information in user_tables (num_rows) is updated whenever an
analyze command is run on the table. The query will work only if
analyze is run on all the tables in the schema prior to the query



Jerry
Received on Wed Dec 03 1997 - 00:00:00 CST












Original text of this message













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