|Subject||RE: [firebird-support] Creating INDEXes on a VIEW|
> In an attempt to clean up a legacy database, we've beenNo! A VIEW is not a table. Any index which is defined for a table will
> 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?
be used by a view as required.
> 1) use an ORDER BY clause in the view definition, andAlthough valid, I would not include include an ORDER BY in a VIEW
> 2) define a new view for each different way of collating
> the information required by the view?