You can never create index on a regular view, except special views with
real stirage data like materialized views..

-----Original Message-----
From: Ryan, Dan [mailto:[Email Address Removed]
Sent: Tuesday, September 30, 2003 4:00 PM
To: LazyDBA.com Discussion
Subject: Indexes on Views


Is it possible in v8.1..7 to create an index on a view?

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page