Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> analyze table with "list chainged rows" or "compute statistics"

analyze table with "list chainged rows" or "compute statistics"

From: David <david_petit_at_yahoo.com>
Date: Sun, 22 Apr 2001 03:15:50 -0700
Message-ID: <3AE2AF56.E61BD2A2@yahoo.com>

Hi all,

   I want to find the number of migrated rows in table testing. I found that I can use "analyze table testing list chainged rows" and "select count(*) from chained_rows" AND "analyze table testing compute statistics" and "select * from dba_tables where table_name = 'TESTING'". Which one is better and faster?

Thanks,
David Received on Sun Apr 22 2001 - 05:15:50 CDT

Original text of this message

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