runstats when adding a new col

MarkhamDBA · #1 (**permalink**) 11-10-09, 11:42

is RUNSTATS on the table/indexes needed after I

- alter a table to add a column,
- drop/change/create PK?

thanks

sathyaram_s · #2 (**permalink**) 11-10-09, 12:22

Quote:

- alter a table to add a column,

Yes, if you are using it in a predicate.

Quote:

- drop/change/create PK?

drop - not necessary
create/change - yes, to get the PK index stats .. If you are creating a PK index before defining the constraint, you can collect statistics when creating the index
CREATE INDEX ..... COLLECT DETAILED STATISTICS

MarkhamDBA · #3 (**permalink**) 11-10-09, 14:45

Quote:

Originally Posted by sathyaram_s

Yes, if you are using it in a predicate.

drop - not necessary
create/change - yes, to get the PK index stats .. If you are creating a PK index before defining the constraint, you can collect statistics when creating the index
CREATE INDEX ..... COLLECT DETAILED STATISTICS

got it. thank so much

Internet Services

Web Development

Digital Marketing

Consumer Tech