> As to whether the index should be in the database. You could,
> for example, create a table for the index data and then define
> a FB index on that table such as this really basic (and
> probably wrong) example:
> CREATE TABLE SECRET_LOOKUP (
> WORD VARCHAR(30) PRIMARY KEY,
> SECRET_TABLE VARCHAR(31),
> LOOKUP_PK INTEGER );

Very wrong! Of course WORD cannot be the primary key, it must
be allowed to occur multiple times.

Hopefully you got the gist anyway. Lots of details to work
through; whether it is worth normalising, what index(es) will
work best in your particular situation and so on.

--
Geoff Worboys
Telesis Computing