From: "Keith Gray" <keith@heart.com.au>
> Is it possible (feasible) to create an index on a view.
>
> We have a large table and a defined sub-set (view)
> from this table, would it be possible to keep an index
> of the sub-set.
I don't think so - the view is basically just a select rule that rewrites
queries based on it.
Indexes on underlying tables should be used though. Difficult to suggest
what indices you might need without knowing the view/tables/queries
involved.
- Richard Huxton