On Feb 17, 2015, at 7:26 AM, Svein Erling Tysvær [email protected] [firebird-support] <[email protected]> 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
