On Feb 17, 2015, at 7:26 AM, Svein Erling Tysvær svein.erling.tysvaer@... [firebird-support] <firebird-support@yahoogroups.com> wrote:

>>
>> Could "Common Table Expressions" or "Derived Tables" bring any advantages?
>
> I suppose you could use a combination of the two suggestions:

[good suggestion omitted]

>
> EXECUTE BLOCK

[and another]

>
> is also an alternative.

The original request mentioned performance. Generally EXECUTE BLOCK requires more processing than a statement that can be prepared once and executed many times.

>

Cheers,


Ann