; <[EMAIL PROTECTED]>
Cc: "Reto Baumann" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, October 13, 2003 12:03 AM
Subject: Re: How does LIMIT affect Query Caching
> In the last episode (Oct 12), Nitin said:
> > query cache doesn't cache the data, but
In the last episode (Oct 12), Nitin said:
> query cache doesn't cache the data, but the execution plan of the
> query. so, in your example it'll treat both query as same, as both
> are fetching data from same result set. query cache just increases
> the speed of query "execution", that means minimi
query cache doesn't cache the data, but the execution plan of the query. so,
in your example it'll treat both query as same, as both are fetching data
from same result set. query cache just increases the speed of query
"execution", that means minimizes the time taken to actually execute the
query,
