are stats affected by these statements?

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

.

Relevant Pages