by "Ana C. Dent" <anacedent@[EMAIL PROTECTED]
>
May 9, 2008 at 04:00 AM
Pat <pat.casey@[EMAIL PROTECTED]
> wrote in news:12a7f1d9-6dce-4ba5-9d41-
73c18ab0dd7e@[EMAIL PROTECTED]
your only tool is a hammer, all problems are viewed as nails.
>
> The classic solution to this is:
> add more memory
What you are attempting to do is covert Physical I/O to Logical I/O.
A smarter solution is to add an index to reduce I/O by orders of
magnitude.