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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement