Hi,

At May 12, 2003, 15:30, sugi wrote:

> PS:
> I don't know much about FB's internals, but wouldn't it be great if
> firebird could somehow keeping a cache of 'computed field's (maintained
> behind the screen on updates, etc) so the values can be indexed (also
> behind the screen) and used by the optimizer if necessary. This way

Actually, expression indices have been talked about for FB 2.0.
Probably being implemented at the same time that there's a change in
the ODS to support larger index keys.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)