But then I seem to remember that via IBO you can provide your
own PLAN ?

============================================================

Geoff Worboys wrote:

>
> > In my last conversation with Jason about this subject,
> > he mentioned that IBOjects generated the PLANS, and
> > how we should fool IB6 to closely match them. Has
> > become a 'gray' are to me now, who is doing what :)
>
> Hi Hans,
>
> AFAIK IBO just retrieves the plan information it does not "generate"
> them. So if IB6 is using the correct plans (and giving good
> performance) then we would need to see if IBO is printing the wrong
> information. But if IB6 is performing badly that would indicate that
> IBO is reporting the correct (bad) plans.
>
> Given the simplicity of the statement I cannot think of anyway to
> force IB to generate a particular plan. I have seen reference
> recently to a bug in IB6 where it is possible in some (rare?)
> situations to end up with two primary keys - the result of which
> neither is used for optimisation.
>
> Have you tried setting up a demonstration in a separate database to
> make sure that you are not being impacted by such possibilities?
>
> Geoff Worboys
> Telesis Computing
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/