Thank you very much for the prompt reply, your workaround worked, it is
definately much faster.
I appologize for the lengthy message I was just trying to ensure that
all information was included, cant wait to get the update onto the
production system to get things up to speed.

Arno Brinkman wrote:

>
> The problem here is that FB doesn't use STARTING WITH and IS NULL
> conjunctions for determing join order. The only way is working around it,
> but because you've a view it becomes more difficult and can effect other
> queries.
>