Progress_Learner
Member
Hi All, hope you all are well!
I am trying to check table and index reads/writes for my queries by using "-tablerangesize, -indexrangesize" db startup parameters but index reads are displaying more then table reads.
Below is one small example:
Here, record reads are coming actual as 83,207 and 873 respectively but Index reads are coming as 84 (customer), 290 (Order) and 1080 (OrderLine). Unable to understand how index reads are more then table reads.
Regards,
I am trying to check table and index reads/writes for my queries by using "-tablerangesize, -indexrangesize" db startup parameters but index reads are displaying more then table reads.
Below is one small example:
Code:
def var icust as int no-undo.
def var iord as int no-undo.
def var iordln as int no-undo.
for each customer no-lock:
icust = icust + 1.
for each order of customer no-lock:
iord = iord + 1.
for each order-line of order no-lock:
iordln = iordln + 1.
end.
end.
end.
message "customer = " icust skip
"Order = " iord skip
"OrderLine = " iordln view-as alert-box.
Here, record reads are coming actual as 83,207 and 873 respectively but Index reads are coming as 84 (customer), 290 (Order) and 1080 (OrderLine). Unable to understand how index reads are more then table reads.
Regards,