Look into recycle pool (BUFFER_POOL RECYCLE).Allocate enough blocks so your query runs same time as in a regular pool. Assign your tables to recycle pool. Run your query. Assign object that is not in a query to the recycle pool as well. Run another query against the object which is not in your original query. I assume it will overwrite cached blocks in a pool and if you run your original query it will take same time.
One, who thinks that the other one who thinks that know and does not know, does not know either!
Reply With Quote