gather_table_stats granularity
I just noticed that gathering statistics on one table partition with above command actually does a full table scan of the whole table (all partitions) instead of gathering only for partition PART2. The command took way too long than it should, which caused me to look at what it was doing. And it appears that … Read more