Xavier Solé schrieb:

>
> Hello listers,
>
> I wonder where I could find any documents referred to query optimization
> (tuning, improve speed). I don't know it this should be Firebird-specific or
> they're just common SQL (or relational database) rules. The fact is that I
> would like to know this "golden rules" that all SQL queries should take into
> account. I've looked at Firebird website but haven't found any docs about
> it.

Tuning is done by making sure the plan the query is using is optimized.

Depending on the tool you're using you can have a look at the generated
plan after preparing a query.

Luc.