On Mar 21, 2011, at 9:55 AM, preetika tyagi wrote:
> For example, if A is 15 minutes, then B is 1.5 hrs.
Well, considering that random disk access is on the order of 10,000 times slower than RAM...
But you can answer the question yourself by comparing the query run against cold caches (after a reboot, or various
command-linetricks to purge cache) vs against warm caches (twice back-to-back).
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice