Re: index on a view ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 6 May 2002 19:11:19 +0200
Message-ID: <udde9m2cvtt896@corp.supernews.com>

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

What is the definition of a view?
So what is your -obvious- answer?

--
Regards


Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Mon May 06 2002 - 12:11:19 CDT