Thread: Where is the generic plan stored when using PREPARE statement?

Where is the generic plan stored when using PREPARE statement?

From
Zhan Li
Date:
Hi All,

According to the document, if a prepared statement is executed enough times, the server may eventually decide to save and re-use a generic plan rather than re-planning each time. My question is where the generic plan is saved? Is it stored in a file in disk? If yes, where is it located and what is the file name?

Thanks,
Zhan

Re: Where is the generic plan stored when using PREPARE statement?

From
Guillaume Lelarge
Date:
On Tue, 2014-02-11 at 10:55 -0500, Zhan Li wrote:
> Hi All,
>
> According to the document, if a prepared statement is executed enough
> times, the server may eventually decide to save and re-use a generic plan
> rather than re-planning each time. My question is where the generic plan is
> saved?

In memory. There's actually no reason to put them on disk.

>  Is it stored in a file in disk? If yes, where is it located and what
> is the file name?
>
> Thanks,
> Zhan


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com