Re: Indexes on a view
From: tina london <tinalondon_at_artemis.demon.co.uk>
Date: Wed, 26 May 1993 17:15:50 +0000
Message-ID: <738436550snz_at_artemis.demon.co.uk>
Date: Wed, 26 May 1993 17:15:50 +0000
Message-ID: <738436550snz_at_artemis.demon.co.uk>
In article <1993May25.192908.8984_at_ctp.com> rvele_at_ctp.com writes:
> Is it possible to put indexes on a view? If so, how and when
>do the indexes get created.
> Thank you in advance.
>
>--
>((((((((((((((((((((((((((((((((((((((((*))))))))))))))))))))))))))))))))))))))
>rvele_at_ctp.com | Cambridge Technology Partners |
>Raymond Velez | 304 Vassar St, Cambridge, MA | (617)739-3739
>((((((((((((((((((((((((((((((((((((((((*))))))))))))))))))))))))))))))))))))))
>
No it isn't as the view is only a text string, which is merged into to the query during parsing.
Put the indexes on the base tables.
-- tina C LondonReceived on Wed May 26 1993 - 19:15:50 CEST