Subject Re: [ib-support] Computed fields vs view
Author Arno Brinkman
Hi Marcin,

> I have to add several fields to my table that will contain month, year and
> week number computed from one date type field. They will be used strictly
> for reporting purposes (grouping etc). I wonder what solution is better -
> add computed fields to the table or create a view with these fields added?

On a computed field you can put indicies which would speed up the query. If
speed is important for you.

Regards,
Arno