The following are the statistics on the table in question :

LOG (140)
Primary pointer page: 332, Index root page: 333
Data pages: 38439, data page slots: 38439, average fill: 82%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 7
60 - 79% = 15851
80 - 99% = 22581

Index IDX_LOGSHIFTNUM (1)
Depth: 3, leaf buckets: 1149, nodes: 179393
Average data length: 0.00, total dup: 179090, max dup: 1400
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 83
60 - 79% = 7
80 - 99% = 1059

Index IDX_LOGSTOCK (2)
Depth: 3, leaf buckets: 1904, nodes: 179394
Average data length: 0.00, total dup: 178417, max dup: 32753
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1659
60 - 79% = 91
80 - 99% = 153

Index IDX_LOG_CLIENT (4)
Depth: 3, leaf buckets: 1422, nodes: 179393
Average data length: 0.00, total dup: 179345, max dup: 32675
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 681
60 - 79% = 5
80 - 99% = 736

Index IDX_LOG_CLNT_SUB (6)
Depth: 3, leaf buckets: 1416, nodes: 179393
Average data length: 0.00, total dup: 179386, max dup: 32675
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 678
60 - 79% = 1
80 - 99% = 737

Index IDX_OPT (3)
Depth: 3, leaf buckets: 1938, nodes: 179394
Average data length: 0.00, total dup: 179357, max dup: 32698
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 1802
60 - 79% = 12
80 - 99% = 123

Index IDX_UPDATELOG (9)
Depth: 5, leaf buckets: 9734, nodes: 179394
Average data length: 29.00, total dup: 4902, max dup: 2748
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 5207
60 - 79% = 33
80 - 99% = 4491

Index RDB$PRIMARY12 (0)
Depth: 3, leaf buckets: 1340, nodes: 179393
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 93
60 - 79% = 0
80 - 99% = 1247

And here are the selectivity indices :

INDEX IDX_LOGSTOCK : 0.001385
INDEX IDX_LOGSHIFTNUM : 0.003460
INDEX IDX_UPDATELOG : 4.7330 E - 5
INDEX IDX_LOGCLIENT : 0.023810
INDEX IDX_LOG_CLNT_SUB : 0.142857


[Non-text portions of this message have been removed]