Subject Re: performance on calculated fields - performance question
Author Virgo Pärna
On Wed, 29 Apr 2015 21:53:09 +0100, Lester Caine lester@... [firebird-support] <> wrote:
> The calculated fields don't actually exist in the database. They are
> created when a record is accessed. What would be better in your case is
> to create the calculated field in a trigger and add it to the record.
> That way the data can be indexed and searched like any other field.

Yes, but CONTAINING would not use index anyway. And it is always possible
tu use computed indexes for computed fields.

Virgo Pärna