[progress Communities] [progress Openedge Abl] Forum Post: Db Analysis Strange Output

  • Thread starter Thread starter Paul Koufalis
  • Start date Start date
Status
Not open for further replies.
P

Paul Koufalis

Guest
OE 11.6.2 - sports database. Is this an error in DB Analysis? Look at the number of records, number of fragments and the frag factor.. -Record Size (B)- ---Fragments--- Scatter Table Records Size Min Max Mean Count Factor Factor PUB.Order 61297 326.4M 53 11098 5584 142065 1.2 1.0 I would expect the frag factor to be 2.3 OR the frag count to be around 74K. Pertinent information: The records were all created in one batch. 326 MB / 4096 blocksize = 83K blocks Doing a FOR EACH on the table reads 82,323 records and 61.298 index per ProTop The frag count is wrong.

Continue reading...
 
Status
Not open for further replies.
Back
Top