On Sun, 2005-12-04 at 13:47 -0500, Pollard, Mike wrote:
> Simon Riggs wrote
> >  The system default is to have a prepared statement
> > bound to a plan on its first parameter bind. 
> 
> We call it deferred optimization.
> 
> Do you really stop at the first parameter?  

The first bind of parameters to the query, yes.

> You
> can do the same thing with correlated subqueries

Not currently done, AFAIK.

Best Regards, Simon Riggs


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Reply via email to