Thomas Miller wrote:

> I disagree, the order does matter. If there is no index, then the order
> matters a lot.
> I don't know enough about FB optimizer, in Oracle, the order is taken in
> account
> by the optimizer...

That's what's called syntactic optimization and most serious database
developers consider it childish. The goal of a relational database is
to reduce the need for the application to understand the mechanics of
data storage and retrieval.


Regards,


Ann