At 10:47 17.10.2002 +0200, you wrote:

>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?

I would say that if speed is more of an issue than disk space and your
table(s) is not very small, you should consider the third alternative -
additional fields populated through triggers. The reason is that I think
neither views nor computed fields can use indexes on fields that are not
physical.

Set