On Feb 17, 2015, at 7:26 AM, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [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