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 -> How to get NUM_ROWS?

How to get NUM_ROWS?

From: EBR <11eebr13_at_hotmail.com>
Date: Sun, 11 Apr 1999 10:48:40 GMT
Message-ID: <37107d75.392221@news.newsguy.com> 





Hi,



I'm using ALL_TABLES and the column NUM_ROWS is always empty. Using
SELECT COUNT(ROWID) FROM table is unreasonable for very large tables.
What can I do to get NUM_ROWS instantly?



Thanks,




EBR



** Please remove the primes to get my real e-mail
Received on Sun Apr 11 1999 - 05:48:40 CDT












Original text of this message













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