Subject | Re: [IB-Architect] computed by index |
---|---|
Author | Nando Dessena |
Post date | 2002-03-06T16:00:33Z |
László,
It seems to me that you are proposing persistent computed fields, which
would be a shortcut over what we have today (that is a real field with a
couple of triggers to keep it in sync), just less flexible (now you can
decide exactly under what conditions to recalculate a value in the
update trigger, whereas a persistent computed field would be
recalculated every time a record is written - unless the engine gets
very very smart).
Is there some other point I am missing?
Ciao
--
____
_/\/ando
> I know, IB can't create index for a computed by column.because a computed column isn't stored and thus it cannot be indexed.
> I see, but WHY CAN'T?
It seems to me that you are proposing persistent computed fields, which
would be a shortcut over what we have today (that is a real field with a
couple of triggers to keep it in sync), just less flexible (now you can
decide exactly under what conditions to recalculate a value in the
update trigger, whereas a persistent computed field would be
recalculated every time a record is written - unless the engine gets
very very smart).
Is there some other point I am missing?
Ciao
--
____
_/\/ando