Re: ref cursor slow compared to sql query

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Mon, 28 Jun 2004 15:25:09 -0500
Message-ID: <jgv0e01amanrq5fmk0kcgnu5dbat0tma3o@4ax.com>

Sybrand Bakker <sybrandb_at_hccnet.nl> wrote:

>On Mon, 28 Jun 2004 10:56:51 -0500, Turkbear <john.g_at_dot.spamfree.com>
>wrote:
>
>>If you are running the Sql immediately after the proc, the data is likely in the cache so it would have a different
>>execution plan.
>
>Please explain why data in the buffer cache would result in a
>different execution plan. What version is that? 11h?

OK, so much for guesswork instead of research...

confused 'explain plan results' with performance issues ( data in buffer would result in faster return from query, but that's not what it was about.. ) Received on Mon Jun 28 2004 - 15:25:09 CDT