ANALYZE TABLE <table_name> COMPUTE STATISTICS => change stats for the table and should should it ANALYZE TABLE <table_name> COMPUTE STATISTICS for COLUMNS => change stats for columns and should change it for columns but NOT for the table
That's it. 2016-06-16 21:10 GMT+02:00 Ashok Kumar <ashok34...@yahoo.com>: > Greeting gurus, > > When I use > > ANALYZE TABLE <table_name> COMPUTE STATISTICS for COLUMNS, > > Where can I get the last stats time. > > DESC FORMATTED <table_name> does not show it > > thanking you >