questions about information info in the sysptprof table

I have a question: I have been tracking table activity and index activity for a couple of weeks and I have a question. In any given hour at a ten minute interval, I would track information in sysptprof ( open tables and indexes that had activity ) and retrieve all data and stuff it into a table. There was one index in particular which is refrencing 81 million rows and it had no isam read activiy but bunches and bunches of buffer reads and seqscan activity. This index has one column. In turn there is another composite index with 6 column names one of which is is the column by which another index is built upon. This index has lots of isread activiy and lots of buffer reads and seqscans. Here is a snapshot: ( sorry about the formatting ) Table name isreads bufreads seqscans gst_game_dtl 70754 80070 1208 ix_gst_game_dtl_1 86238 292065 15769 ix_gst_game_dtl_1 90655 310577 16442 gst_game_dtl 65380 77834 1219 gst_game_dtl 63239 76446 1205 ix_gst_game_dtl_1 86638 295378 16437 gst_game_dtl 61262 73902 1223 ix_gst_game_dtl_1 91742 309226 16059 gst_game_dtl 66095 78699 1206 ix_gst_game_dtl_1 90222 314087 16023 gst_game_dtl 62392 76020 1255 ix_gst_game_dtl_1 94035 314269 16102 gst_game_dtl 66729 79240 1245 ix_gst_game_dtl_1 93800 321089 16216 gst_game_dtl 65661 78207 1269 ix_gst_game_dtl_1 95213 314168 15868 gst_game_dtl 60227 71794 1233 gst_game_dtl 62920 76066 1211 ix_gst_game_dtl_1 93154 312069 16243 ix_gst_game_dtl_1 91001 314256 15766 gst_game_dtl 60359 72367 1223 ix_gst_game_dtl_1 88472 301409 15935 gst_game_dtl 64195 76138 1206 ix_gst_game_dtl_1 93954 317510 16129 gst_game_dtl 68566 84591 1235 ix_gst_game_dtl_1 87117 303246 16264 ix_gst_game_dtl_1 98574 349452 16323 gst_game_dtl 59163 72364 1216 ix_gst_game_dtl_2 0 374597 64256 ix_gst_game_dtl_3 0 374917 45767 As you can see there is no isam activity but there is some buffer activity. My question is this, why would I not see any isread activity on this index? Is it because the information is cached and the index hit is done out of memory? I have my theories, but I am not sure.... Thanks, Carlos Bolden Database Administrator cbolden@harrahs.com