http://stackoverflow.com/questions/4323961/crosspost-wordpress-blog-post-to-blogger
SELECT table_name,
num_rows
FROM ALL_TABLES a
WHERE TABLE_NAME like 'MDA%'
AND OWNER='MDM_DEV2'
order by table_name;
This command can refresh the statistics in the ALL_TABLES
exec dbms_stats.gather_schema_stats('MDM_DEV2');
No comments:
Post a Comment