Statistics for rearranged columns

scrimpton
New Contributor II

The table property dataSkippingNumIndexedCols that gets statistics for a table starts from left to right. I am wondering what will happen to the statistics for both new and old records if we add a column in between using FIRST|AFTER identifier.

Vince_03_0-1696039970438.png