Hi Arno,

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

Since when?


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."