>> In few words, index is absolutely necessary.
>>
>In my application I need index on calculated column.
>As FB doesn't allow index on such columns, I use following trick:

Newer versions of Firebird support expression based indices.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com