Subject Creating INDEXes on a VIEW
Author Brian L. Juergensmeyer
Greetings, all:

In an attempt to clean up a legacy database, we've been looking at revamping
some of the tables and using views (the database with which we're working
currently does not use views at all). A coworker had a question that I
couldn't answer: Is it legal to define an index on a view? Or, is the
thought that you should just 1) use an ORDER BY clause in the view
definition, and 2) define a new view for each different way of collating the
information required by the view?

Thanks in advance for any asstance,