Subject | Re: [ib-support] Computed fields vs view |
---|---|
Author | Arno Brinkman |
Post date | 2002-10-17T09:58:23Z |
Hi,
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
> >On a computed field you can put indicies which would speed up the query.If
> >speed is important for you.No, i was definitly wrong :-( as martijn asked when -> never.
>
> Arno is probably right, I wasn't aware of this since I never use them.
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