Hi, pardon me for jumping in

> I recently was just able to speed up a couple of SPT by just putting an index on the FB database. I had originally started with tackling it on remote view (lots of C5 in those days) then promoted myself to SPT.

The requirement for indexes in Firebird is the same: Selectivity, as high as is possible. Do this and it will be happy - You don't get burned :).

A SET STATISTICS INDEX {index} can be useful from time to time, specially after a bulk load.