Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pratheepsen
Starting Member
8 Posts |
 Posted - 2007-05-10 : 06:51:31
|
| before rebuild index---------------------tablename Indexname avg_fragmentation_in_percentPayoff_Quote PK_Payoff_QuoteDetail 83.3333333333333ALTER INDEX ALL ON Payoff_Quote REBUILDafter issue the above statement result remain same. |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-05-10 : 09:52:17
|
| I will guess the table has exactly 6 pages. |
 |
|
|
|
|
|
Index fragmentation