Hi All,
We're looking at doing some spring cleaning on our database and want to look at removing some indexes. We plan to monitor the _IndexStat over the next month or so and see what Indexes are being used and which aren't.
Currently i've run a few tests and wanted to check what the fields actually mean, as this is the output:
Progress does provide the following:
OpenEdge 11.6 Documentation
But it doesnt quite explain it!
Essential, a read is a read and a create must occur for each new record so this could be discarded as reason not to delete an index. But what about deletes and splits?
I wouldnt have been too bothered about deletes had idxCost not come in with over 7000 hits.
Any details on this would be greatly appreciated.
thanks
We're looking at doing some spring cleaning on our database and want to look at removing some indexes. We plan to monitor the _IndexStat over the next month or so and see what Indexes are being used and which aren't.
Currently i've run a few tests and wanted to check what the fields actually mean, as this is the output:
Code:
"Index Num" "Table Name" "Index Name" "Reads" "Splits" "Creates" "Deletes" "Total"
619 "Customer" "idxCustomerCode" 0 91 90865 4 90960
620 "Customer" "idxLastPurchase" 38840 712 91484 4 131040
621 "Customer" "idxPrevPurchase" 136601 490 91261 4 228356
622 "Customer" "idxItemcode" 58884138 42 90817 4 58975001
623 "Customer" "idxCost" 0 248 98129 7113 105490
624 "Customer" "idxNumber" 0 119 90891 4 91014
625 "Customer" "idxDate" 0 14 90789 4 90807
626 "Customer" "idxType" 0 589 91362 4 91955
618 "Customer" "idxOrder" 8772742 511 91278 4 8864535
627 "Customer" "idxName" 0 525 91301 5 91831
628 "Customer" "idxSeq" 0 252 1026 4 91282
Progress does provide the following:
OpenEdge 11.6 Documentation
But it doesnt quite explain it!
Essential, a read is a read and a create must occur for each new record so this could be discarded as reason not to delete an index. But what about deletes and splits?
I wouldnt have been too bothered about deletes had idxCost not come in with over 7000 hits.
Any details on this would be greatly appreciated.
thanks
Last edited: