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

However, it does raise a question -- what happens with the
Firebird optimizer if there's a bunch of columns in the WHERE
clause and none of them have indices.

:-)

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com