Re: CREATING VIEWS

You can't create indexes on view, only the underlying base tables.

ascott_at_aol.com (AScott) wrote:

>Hi,
>
>Does anyone have the answer to the following:
>
>I have created a view based on three tables. How does one create indexes
>on the view? I have tried but failed miserably.
>
>
>Cheers
>
>Andy

-JJ

Visit our new website at http://www.jeffreyjacobs.com

 Jeffrey Jacobs & Associates
 Oracle Designer/2000 Consulting & Training  951-2 Old Country Road, Suite 119, Belmont, CA 94002  Voice: 650-571-1457, FAX: 800-665-1379
 Email: jmjacobs_at_ix.netcom.com
 Web: http://www.jeffreyjacobs.com

Don't miss ODTUG's Spring Conference, June 2-5, Palm Spring, CA. See http://www.odtug.com for more information! Received on Sat Feb 21 1998 - 00:00:00 CET