For Oracle masters!

From: blarut <blarut_at_wp.pl>
Date: 16 Mar 2006 13:46:43 -0800
Message-ID: <1142545603.312083.230740@v46g2000cwv.googlegroups.com>

I am testing Oracle
I have small table (76,000 records). I have index on one column. I am testing 100 queries which use this index (WHERE indexed_column =...) I am using also utbstat and utestat statistic. and I see that my 100 queries don't make any I/O operations. I try it a lot of time and still the same. I test it after startup the instance so the data should't be in cache. Could you explain it? Received on Thu Mar 16 2006 - 15:46:43 CST