are stats affected by these statements?

bravegag · *nix forums beginner Joined: 12 Apr 2006 Posts: 16

Hi all,

Suppose you compute stats on table A, do you lose them if:

- the table is dropped right after?
- the table is truncate right after?
- the table is reorganized rebuild right after?
- the table is altered in any way like e.g. paritions?

In general do DDLs like the above overwrite in any
way existing previously collected statistics on a table?

Same for indexes?

Many many thanks in advance,
Best Regards,
Giovanni

Google