Create an index on a view?

[GT98SVO]

CREATE INDEX Hierarchy_Div_ID ON CPSADMIN.Hierarchy_VW(CP_DIVISION_ID);

Oracle Error: View not appropriate here.

Using Oracle 8i(8.1.7).

Much thanks

 

[jimbopalmer]

You can create indexes on the underlieing tables I tried to remain child-like, all I acheived was childish.

 

[karluk]

Oracle 8i doesn't allow indexes to be created on views. That's why you're seeing the error.

This limitation is not true on other databases. For example, SQL Server 2000 does allow indexes on views, as I found out recently, much to my surprise.

 

[palwinder]

oracle does not allow creation of indexes on views because when a query is executed on the view it usess indexes of underlying tables. Instead you can analyze the query to find out if your query on view is using indexes of the underlying tables.

 

[GT98SVO]

much thanks!