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?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.