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


> >On a computed field you can put indicies which would speed up the query.
If
> >speed is important for you.
>
> Arno is probably right, I wasn't aware of this since I never use them.

No, i was definitly wrong :-( as martijn asked when -> never.

Ofcourse you can't put indicies on computed fields.
The way with using triggers to update year,month, and day columns as SET
suggested you can use indicies.

Sorry !

Regards,
Arno