RE: QUICK Embedded SQL Question

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Rick

I'm going to guess not. PREPARE is, as you know, a dynamic SQL process. I 
may be wrong, but I think PREPARE is where the optimizer does its thing. 
With static SQL, that optimization is done at program creation, and there 
may be an estimate then. Unfortunately, that estimate (and maybe the one 
from PREPARE) may have little to do with future reality.

Vern

At 08:44 AM 2/9/2004 -0600, you wrote:
> I was hoping with your experience using SQL you would have an answer for 
> this.  I'll have to remember that one.
>
> Is there a way to get an estimate if the statement is not prepared?  I do 
> a lot of work with static SQL statements.
>
> Rick
>
> > -----Original Message-----
> > From: midrange-l-bounces@xxxxxxxxxxxx
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Vern Hamberg
> > Sent: Friday, February 06, 2004 5:18 PM
> > To: Midrange Systems Technical Discussion
> > Subject: RE: QUICK Embedded SQL Question
> >
> >
> > Apparently SQLER3 also contains the estimated number of rows
> > when a PREPARE
> > of a SELECT is done.
> >
> > Vern
> >
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.