[DUG] Why InterBase

Karl at Work karlreynolds at xtra.co.nz
Fri Jun 2 11:52:52 NZST 2006


> Incidentally, do others know that it is possible to add calculated
> fields in firebird/interbase that actually obtain their value from
> stored procedures.  It makes the database very powerful.  The
> drawback
> is that you better not do select * accidentally.  :-)

Unfortunately you can't generate even temporary indices on these calculated
fields, so if you rely on them in a where clause, your query runs like a dog
with no legs.

Cheers,
Carl



More information about the Delphi mailing list