Subject Re: [firebird-support] SQL Performance help
Author Helen Borrie
At 12:45 PM 6/11/2006, you wrote:

> > FWIW, I recommend that you keep right away from a solution that
> > requires joining to or subquerying stored procedures. I would rather
> > lie down in front of a train.
> >
> >
>Hi Helen
>I got your email after posting my solution (which does use a joined
>SP). The performance is great and since I cant use FB2s derived tables
>(yet) then it seems a reasonable solution. Why shouldn't I join a SP or
>do you like lying down in from of trains :)

1. The SP has to complete before the joining can begin
2. Can't use indexes for the join since an SP outputs virtual data

An SP is cool for this kind of job - as long as you make sure it does
the whole of the job. Indexes will be used *inside* the SP.

And, no, being run over by a train is not my preferred way to's just preferable to *that* alternative. :-)