Subject Re: [firebird-support] Which is quicker?
Author Ann W. Harrison
tomconlon7777777 wrote:
> INSERT INTO qrytmp1 ...
> 1. SELECT id FROM x (qtype default fires)
> 2. SELECT id, 'C' FROM x (qtype explicit)
> 3. SELECT id, 'C' FROM x (lose default, qtype explicit)
> Is (3) is the quickest?

The default is evaluated at compile time and turned into part of
the insert statement... I suppose you've got an extra if test
in the inner loop, but in 2 & 3 you're evaluating two input values.
My guess is it won't make much difference either way.