> You don't necessarily need to use a full compound index. Firebird can use more than one index, so you don't have to use a single compound index, it is just that in some cases using a compound index is more efficient; if it actually is, depends on your situation.

yes, it's my begining problem : "depends on your situation" :) on some case yes, on some other case not :(