Oracle Database Discussions

Hi All,

This is probably a stupid question, but I've searched high and low and haven't found a suitable answer to the following: When do stats get dropped?

I've read that table and index stats get dropped whenever you truncate a table, but the (minimal) testing I've done doesn't bear this out. By "testing", I mean I've tried truncating a table then exporting and viewing the table stats via DBMS_STATS.EXPORT_TABLE_STATS (well I did say 'minimal')... The table stats don't appear to have been dropped following truncation.

Do table / index stats get dropped when you truncate / drop / delete all records from a table? Or do they not get dropped at all?