Quote:
Originally posted by slimdave
True, but it's not going to go up by very much, because the column values are still clustered, they're just not all in one single cluster. As long as each load cycle has enough rows that each value of the clustered column spans a reasonable number of blocks (say, a thousand or so) then having 100 individual clusters of 1000 blocks is going to show up as almost the same clustering factor as having a single cluster of 100,000 blocks.
I still mantain, will that significantly change the plan.. ? (depends but most often not)..