acceptable buffer reads per execution..

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Tue, 28 Jan 2003 16:17:03 GMT
Message-ID: <3e36acfe.3607044285@nyc.news.speakeasy.net>

is there are a 'rule of thumb' for the maximum buffer reads per execution?

I have a number of queries and procedures that range from 200 to 500 buffer reads per execution and execute 1000's to 100000's times per day. Some of the queries just require a lot of data to execute, but I was curious if it was worth starting to look into 'materialized views' and 'function based indexes' to try to minimize CPU usage by those queries.

Thanx.
.......
We use Oracle 8.1.7.3 on Solaris 2.7 boxes remove NSPAM to email Received on Tue Jan 28 2003 - 10:17:03 CST