![]() |
|
|||||||
| Notices |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Guest
Posts: n/a
|
Big Mistake? - Indexes with includes on partition tables
I recently tried adding include columns to two indexes, one on each of two
partitioned tables. The tables are modest-sized, fact tables used for aggregation. Each week, we slide the partitions. The slide process is normally very fast. However, after adding include columns to the indexes, the command to split the range in the partition functions resulted in what appears to be runaway processes that gobbled up system resources and maxxed out the transaction log. In fact, even after emptying the tables of data and dropping the indexes, this happened. It was only after I deleted the index partition scheme that the problem went away. So... is there a problem with creating indexes with include columns on partitioned tables where the partitions will slide? Is there something exponential that goes on? Thanks -- Thanks, CGW |
|
![]() |
| Thread Tools | |
| Display Modes | |
|
|
< Windows Help - MS Office Help - Hardware Support >
| New To Site? | Need Help? |