DBAWinnipeg
Programmer
Gooooooood Morning everyone
Quick question for you folks
I have a table with approx 1/2 million rows and I performed a reindex on (for argument sake) idx_1
Now the Scan Density before the reindex was 70% and Logical Frag was 4%
and after
The Scan Density is 100% (good) but the logical Frag went up to 12%
Any ideas as to why/how this happens?
Keeping in mind this is during off hours when no one is accessing the information
Thanks in advance!!!
Colin in da 'Peg
Quick question for you folks
I have a table with approx 1/2 million rows and I performed a reindex on (for argument sake) idx_1
Now the Scan Density before the reindex was 70% and Logical Frag was 4%
and after
The Scan Density is 100% (good) but the logical Frag went up to 12%
Any ideas as to why/how this happens?
Keeping in mind this is during off hours when no one is accessing the information
Thanks in advance!!!
Colin in da 'Peg