I want to chat with filipi alcoholic dating patterns
I expect you'll have guessed from the title of this post that I’m going to assume that from now on!
I'm also going to assume that the statistics on SALES are up-to-date prior to the partition exchange load.
Most of you will be familiar with partition exchange load, but I’ll summarize it briefly to introduce you to the terminology I’ll be using here. Firstly, the LOAD table is filled with new data and then exchanged with a partition in the “live” application table (SALES).
SALES has partitions for quarter 1 and quarter 2 (Q1 and Q2) and LOAD is exchanged with the empty Q2 partition.
In the example above, the global-level statistics for SALES must be refreshed to reflect the data incorporated into the table when LOAD is exchanged with Q2.