i did do an explain analyze on the query by running the query directly on
the database.
just wondering if there was a way to get the execution plan for the
prepared statement.
On Wed, Nov 9, 2011 at 9:57 PM, Oliver Jowett <oliver(at)opencloud(dot)com> wrote:
> On 10 November 2011 17:44, Timbo Chen <timbo(at)powerreviews(dot)com> wrote:
> > what could be the possible reason that these 2 nearly identical queries
> have
> > such different performance?
>
> > different execution plans?
>
> Yes.
>
> > how would i find out what the actual execution
> > plan was?
>
> EXPLAIN ANALYZE?
>
> Oliver
>