Kjell Rilbe skriver:

> Ann W. Harrison skriver:
>> > Also, what considerations should I make regarding page size? Maybe I
>> > should bump up the page size?
>>
>> How deep are your indexes?

Seems that on the largest table, they all have depth 4. Are there any
figures in this report that would warrant a config change or anything,
e.g. different page size?

Analyzing database pages ...
Uppgift (567)

Index IX_PK_Uppgift (0)
Depth: 4, leaf buckets: 588728, nodes: 131418408
Average data length: 5.08, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 2968
20 - 39% = 15
40 - 59% = 279494
60 - 79% = 185021
80 - 99% = 121230

Index IX_Uppgift_BorttagsuppA5K (8)
Depth: 4, leaf buckets: 253733, nodes: 136466214
Average data length: 0.00, total dup: 136444473, max dup: 119722141
Fill distribution:
0 - 19% = 127
20 - 39% = 7685
40 - 59% = 131314
60 - 79% = 28000
80 - 99% = 86607

Index IX_Uppgift_F├Ârr├Ñdsv├ñrde (7)
Depth: 4, leaf buckets: 293233, nodes: 131520245
Average data length: 0.01, total dup: 131518324, max dup: 92132562
Fill distribution:
0 - 19% = 4
20 - 39% = 9
40 - 59% = 278194
60 - 79% = 10899
80 - 99% = 4127

Index IX_Uppgift_Hållare (4)
Depth: 4, leaf buckets: 547077, nodes: 131649325
Average data length: 4.43, total dup: 17045909, max dup: 127020
Fill distribution:
0 - 19% = 3121
20 - 39% = 2
40 - 59% = 157508
60 - 79% = 276535
80 - 99% = 109911

Index IX_Uppgift_Länkobjekt (5)
Depth: 4, leaf buckets: 171915, nodes: 131726120
Average data length: 0.00, total dup: 131726119, max dup: 131726119
Fill distribution:
0 - 19% = 13
20 - 39% = 0
40 - 59% = 16321
60 - 79% = 8550
80 - 99% = 147031

Index IX_Uppgift_RelateradHåIS0 (6)
Depth: 4, leaf buckets: 280149, nodes: 131766586
Average data length: 0.05, total dup: 130480063, max dup: 130452477
Fill distribution:
0 - 19% = 9
20 - 39% = 1
40 - 59% = 262222
60 - 79% = 14551
80 - 99% = 3366

Index IX_Uppgift_TilläggsuppYNC (9)
Depth: 4, leaf buckets: 196830, nodes: 131804550
Average data length: 0.02, total dup: 131766961, max dup: 11251
Fill distribution:
0 - 19% = 9
20 - 39% = 1
40 - 59% = 3217
60 - 79% = 44
80 - 99% = 193559

Index IX_Uppgift_Uppgiftsägare (2)
Depth: 4, leaf buckets: 189653, nodes: 131832678
Average data length: 0.00, total dup: 131832676, max dup: 131822466
Fill distribution:
0 - 19% = 9
20 - 39% = 1
40 - 59% = 57958
60 - 79% = 8641
80 - 99% = 123044


Regards,
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64