SQL Statment

[pinakpatel]

SQL> SELECT SUBSTR(TABLE_NAME,1,10) TABLE_NAME, SUBSTR(OWNER,1,6) OWNER,
2 BLOCKS, NUM_ROWS, EMPTY_BLOCKS
3 FROM DBA_TABLES
4 WHERE TABLE_NAME IN ('ACCTHD','ACCTIT','ACCTCR','GLPCA');

TABLE_NAME OWNER BLOCKS NUM_ROWS EMPTY_BLOCKS
---------- ------ --------- --------- ------------
ACCTCR SAPR3
ACCTHD SAPR3
ACCTIT SAPR3
GLPCA SAPR3

SQL> SELECT COUNT(*) FROM SAPR3.ACCTCR;

COUNT(*)
---------
107002

SQL> SELECT COUNT(*) FROM SAPR3.ACCTHD;

COUNT(*)
---------
16284

SQL> SELECT COUNT(*) FROM SAPR3.ACCTIT;

COUNT(*)
---------
53501

SQL> SELECT COUNT(*) FROM SAPR3.GLPCA;

COUNT(*)
---------
188399

Any comments on above SQL Statment.....

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle7 Server Release 7.3.4.3.0 - Production
PL/SQL Release 2.3.4.3.0 - Production
CORE Version 3.5.4.0.0 - Production
TNS for IBM/AIX RISC System/6000: Version 2.3.4.0.0 - Production
NLSRTL Version 3.2.4.0.0 - Production


[Edited by pinakpatel on 12-14-2001 at 11:15 AM]

[marist89]

Sure, the tables haven't been analyzed.