Subject Re: [firebird-support] Creating INDEXes on a VIEW
Author Brian L. Juergensmeyer
Hello, Sean,

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

We would need to be able to use some form of indexing on the result set (be
it an ORDER BY in the view definition or indexing the underlying tables) in
order to retrieve data indexed in a certain way.

Why would you not include an ORDER BY in a VIEW definition?