G
gus
Guest
geroge, i have a similar program, but yours is better. regards, Gus Bjorklund, BravePoint MDBA Services gus@progress.com > On Nov 20, 2015, at 9:29 AM, George Potemkin wrote: > > Update from Progress Community [https://community.progress.com/] > > George Potemkin [https://community.progress.com/members/georgep12] > >> imo, it is a largely useless metric. > > It can't explain/predict, for example, how long dbanalys will scan RM chains. Of course, an application does not scan these chains. But scatter factor can't also explain the time to scan the free cluster chain - the clusters that were owned by the real but now deleted objects. Dbanalys scans them a few times slowes than the sequencial scan dirung "Area Block Analys" phase. > >> more useful to know would be "if i use index x, how well does its ordering match the physical storage ordering and how many i/o's will that require?" > > It's exactly what my SeekRatio.p program does: > ftp.progress-tech.ru/.../SeekRatio.p > You can see the huge difference between the indexes even in the sports database. > > Best regards, > George > > View online [https://community.progress.com/community_groups/openedge_rdbms/f/18/p/21437/75564#75564] > > You received this notification because you subscribed to the forum. To unsubscribe from only this thread, go here [https://community.progress.com/community_groups/openedge_rdbms/f/18/t/21437/mute]. > > Flag [https://community.progress.com/community_groups/openedge_rdbms/f/18/p/21437/75564?AbuseContentId=6e578aaa-95ae-4d6e-a816-425a8bc0993a&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true] this post as spam/abuse.
Continue reading...
Continue reading...