My understanding of how Firebird uses Primary keys and indexes are below.
If there is a Primary Key or Index available, the Optimizer will use it.

I come from an AS400 environment. The programmer chooses the index
(logical) to be used not the database. How does the optimizer choose,
and what types of problems arise from that situation? Can I choose
the index to be used rather than the optimizer?

MIKE