|Subject||Re: [IB-Architect] Re: Proxy Query ?|
|Author||Ann W. Harrison|
> > From: Dalton Calford <dcalford@...>At 09:06 AM 3/8/2001 -0500, Craig Stuntz wrote:
> > I do not think that the metadata compiler should even check for the
> > presence of the remote database during metadata operations.
> That's an interesting thought, because the implications are muchOptimization is done at run time. Compilation into BLR is done when
>Doing this would mean the statements can't be optimized until runtime (even
>if the "remote" DB were accessible at design time, the index statistics
>might not reflect what will be in the "real" "remote" DB at runtime). And
>(optionally) deferring optimization to runtime might have other
>advantages -- the ability to build statements "on the fly" in a stored proc
>would be useful, for instance.
a procedure is defined, but BLR has no optimization. Compilation into
We have answers.