"Meier Roland" <Roland_Meier_at_freesurf.ch> wrote in message news:<ab6apl$fot$1_at_rex.ip-plus.net>...
> Dear all
>
> I would like to create a view over 3 tables containig about 250000 rows
> each. But the view is terribly slow. Is there a way to create an index on a
> view ? I am not shure whether this is possible with materialized views,
> didnt find anything about it.
>
> Can anyone give me a hint ?
>
> Thank you
>
> Roland
Materialized views are just table snapshots. As tables, they can
definitely be indexed. Normal views? No.
Received on Tue May 07 2002 - 09:02:59 CDT
