Re: index on a view ?

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Mon, 6 May 2002 19:26:50 +0100
Message-ID: <3cd6caed$0$8508$cc9e4d1f@news.dial.pipex.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 ?

a normal view will use any underlying indexes and because it is a 'compiled' select statement can also use hints in its definition.

a materialized view creates a bona fide table so can be indexed directly

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Mon May 06 2002 - 13:26:50 CDT