[Progress Communities] [Progress OpenEdge ABL] Forum Post: Table reads versus index reads

  • Thread starter Thread starter gdb390
  • Start date Start date
Status
Not open for further replies.
G

gdb390

Guest
We have a table AD with 1564 records The table has several indexes. One index is the index ADADRESKEY with 1 field ADRES (ascending). All indexes have been rebuild. We start the database with proserve command We execute the below query : for each ad no-lock where ad.adres = "def" : display naam adres. end. There is one record that is shown. Table statistics show the following numbers : First execution : table reads AD : 2 , Index reads ADADRESKEY : 3 Second (and all after that) execution : table reads AD : 1, index reads ADADRESKEY : 3 Two questions : * where is the number two coming from in the first execution ( has this something to do with the loading of schema information ?) * where does the number 3 comes from in the index reads ?

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