Query
------------------------------------------------
select count(*)
from SOME_TABLE t1
join SOME_TABLE t2 on t2.ID>t1.ID;


Plan
------------------------------------------------
PLAN JOIN (T1 NATURAL, T2 INDEX (RDB$PRIMARY414))

Adapted Plan
------------------------------------------------
PLAN JOIN (T1 NATURAL, T2 INDEX (INTEG_4445))

Query Time
------------------------------------------------
Prepare       : 16.00 ms
Execute       : 0.00 ms
Avg fetch time: 0.00 ms

Memory
------------------------------------------------
Current: 35 435 744
Max    : 68 661 424
Buffers: 2 048

Operations
------------------------------------------------
Read   : 0
Writes : 0
Fetches: 119
Marks  : 0


Enchanced Info:
+-------------------------------+-----------+-----------+-------------+---------+---------+---------+----------+----------+----------+
|          Table Name           |  Records  |  Indexed  | Non-Indexed | Updates | Deletes | Inserts | Backouts |  Purges  | Expunges |
|                               |   Total   |   reads   |    reads    |         |         |         |          |          |          |
+-------------------------------+-----------+-----------+-------------+---------+---------+---------+----------+----------+----------+
|SOME_TABLE                     |         0 |        36 |           9 |       0 |       0 |       0 |        0 |        0 |        0 |
+-------------------------------+-----------+-----------+-------------+---------+---------+---------+----------+----------+----------+