Hi all!
What is the syntax for deleting statistics in table..
From Analyze table scott.emp compute statistics;
also, is there anything special i have to do to delete those statistics...
Thanks!
Printable View
Hi all!
What is the syntax for deleting statistics in table..
From Analyze table scott.emp compute statistics;
also, is there anything special i have to do to delete those statistics...
Thanks!
In checking the SQL reference manual (which you should have),
ANALYZE TABLE my_table DELETE STATISTICS;