Discussion on:
Message 1 of 2
Other indexes on partitioned table
Many examples suggest partitioning across multiple filegroups, disks - given a sliding window scenario using partitions on multiple disks, would you suggest indexes not used in the partition schema be partitioned or on their own filegroup (possibly PRIMARY)? When switching in and out partitions, will the stats be recalculated?
Posted by conrad.schilbe@...
14th Oct 2008

































