Folks, need to pick your brains.. trying to save some processing time.. optimise the process.
I have a table with 2.5 million records with 25 fields. Currently I’m dropping the table and recreating it from scratch. Creating the index (on billing telephone number) and collecting stats (on BTN)
Q1: would it be much faster if I would just delete, insert, re-index, collect stats?
Q2: since the table is indexed and partitioned by billing Telephone number, is it necessary to collect stats? The stats would be on the same index field? Since it’s partitioned why do an extra step?