> 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?

No! A VIEW is not a table. Any index which is defined for a table will
be used by a view as required.

> 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?

Although valid, I would not include include an ORDER BY in a VIEW
definition.


Sean