Originally posted by patnams
By your post, you are obviousely testing your queries.
I dont know if this works ..
1. Reduce the the Buffer Size
2. Create a table large enuf with junk data that can fill up your Data Buffer.
3. Run your Query
4. Run a Query on the large table, buffers are replaced
5. Run you Query
You want HIM to do it on a production box ?????