Hello Geoff,

OK. Now I understand IBO is 'PLAN ReadOnly'.

After having this update running overnite without completion, I
wrote the update in a procedure, like you and Helen suggested
and the update completed in 2 mins.

For the 'production' stuff, I tend to stuff almost every task in the
server as views, triggers, procedures, but sometimes you have that
one task to do only once and want to use a quick and dirty obvious
way :)

Best Regards,
Hans

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

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/