Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> analyze table with "list chainged rows" or "compute statistics"
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