i have a table which has 5 million records partitioned by 366 day wise partitionandhavinglast 20 daysof record.
the table partitioned Index becomes 98% fragmentation for 5K record insertion. Can some one help on this to resolve ?
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Answers Answers and Comments
18 People are following this question.
A small suggestion in SQl Partition? urgent please
Get unique partition number to the table partitions on the same column in a database
FILLFACTOR and SSD storage
What does percent of index fragmentation literally mean?
Summing Sequential Data In A Table