> What duplicate index?

I have the primary key and then the foreign key constraint causes
FireBird to create another index where it could use the primary key as
well.

SPLIT (133)
Primary pointer page: 144, Index root page: 145
Data pages: 41732, data page slots: 41732, average fill: 59%
Fill distribution:

Index FK_SPLIT_SWIMRESULT (1)
Depth: 3, leaf buckets: 4903, nodes: 12644728
Average data length: 0.00, total dup: 8582539, max dup: 199
Fill distribution:

Index PK_SPLIT (0)
Depth: 3, leaf buckets: 6999, nodes: 12644728
Average data length: 3.00, total dup: 0, max dup: 0



cu Christian