SELECT
    ABONENT.ID
FROM
    DIR$ABONENT$ABONENT AS ABONENT
--    LEFT JOIN DIR$ABONENT$DEVIANT_BEH AS DEVIANT_BEH ON ABONENT.ID_DEVIANT_BEH = DEVIANT_BEH.ID
    INNER JOIN DIR$HOUSE$HOUSE AS HOUSE ON HOUSE.ID = ABONENT.ID_HOUSE
    INNER JOIN DIR$UNIT$UNIT AS UNIT ON UNIT.ID = HOUSE.ID_UNIT
WHERE
    UNIT.ID = 98

PLAN JOIN (UNIT INDEX (PK_DIR$UNIT$UNIT), HOUSE INDEX (FK_DIR$HOUSE$HOUSE_UNIT), ABONENT INDEX (FK_DIR$ABONENT$ABONENT_HOUSE))

+-------------------------------+-----------+-----------+-------------+---------+---------+---------+----------+----------+----------+
|          Table Name           |  Records  |  Indexed  | Non-Indexed | Updates | Deletes | Inserts | Backouts |  Purges  | Expunges |
|                               |   Total   |   reads   |    reads    |         |         |         |          |          |          |
+-------------------------------+-----------+-----------+-------------+---------+---------+---------+----------+----------+----------+
|DIR$ABONENT$ABONENT            |         0 |       151 |           0 |       0 |       0 |       0 |        0 |        0 |        0 |
|DIR$HOUSE$HOUSE                |         0 |         3 |           0 |       0 |       0 |       0 |        0 |        0 |        0 |
|DIR$UNIT$UNIT                  |         0 |         1 |           0 |       0 |       0 |       0 |        0 |        0 |        0 |
+-------------------------------+-----------+-----------+-------------+---------+---------+---------+----------+----------+----------+

SELECT
    ABONENT.ID
FROM
    DIR$ABONENT$ABONENT AS ABONENT
    LEFT JOIN DIR$ABONENT$DEVIANT_BEH AS DEVIANT_BEH ON ABONENT.ID_DEVIANT_BEH = DEVIANT_BEH.ID
    INNER JOIN DIR$HOUSE$HOUSE AS HOUSE ON HOUSE.ID = ABONENT.ID_HOUSE
    INNER JOIN DIR$UNIT$UNIT AS UNIT ON UNIT.ID = HOUSE.ID_UNIT
WHERE
    UNIT.ID = 98

PLAN JOIN (JOIN (JOIN (ABONENT NATURAL, DEVIANT_BEH INDEX (PK_DIR$ABONENT$DEVIANT_BEH)), HOUSE INDEX (PK_DIR$HOUSE$HOUSE)), UNIT INDEX (PK_DIR$UNIT$UNIT))

+-------------------------------+-----------+-----------+-------------+---------+---------+---------+----------+----------+----------+
|          Table Name           |  Records  |  Indexed  | Non-Indexed | Updates | Deletes | Inserts | Backouts |  Purges  | Expunges |
|                               |   Total   |   reads   |    reads    |         |         |         |          |          |          |
+-------------------------------+-----------+-----------+-------------+---------+---------+---------+----------+----------+----------+
|DIR$ABONENT$ABONENT            |         0 |         0 |       19733 |       0 |       0 |       0 |        0 |        0 |        0 |
|DIR$ABONENT$DEVIANT_BEH        |         0 |         1 |           0 |       0 |       0 |       0 |        0 |        0 |        0 |
|DIR$HOUSE$HOUSE                |         0 |     19733 |           0 |       0 |       0 |       0 |        0 |        0 |        0 |
|DIR$UNIT$UNIT                  |         0 |       151 |           0 |       0 |       0 |       0 |        0 |        0 |        0 |
+-------------------------------+-----------+-----------+-------------+---------+---------+---------+----------+----------+----------+

SELECT
    ABONENT.ID
FROM
    DIR$UNIT$UNIT UNIT
    INNER JOIN DIR$HOUSE$HOUSE AS HOUSE ON HOUSE.ID_UNIT = UNIT.ID
    INNER JOIN DIR$ABONENT$ABONENT AS ABONENT ON ABONENT.ID_HOUSE = HOUSE.ID
    LEFT JOIN DIR$ABONENT$DEVIANT_BEH AS DEVIANT_BEH ON ABONENT.ID_DEVIANT_BEH = DEVIANT_BEH.ID
WHERE
    UNIT.ID = 98

PLAN JOIN (JOIN (UNIT INDEX (PK_DIR$UNIT$UNIT), HOUSE INDEX (FK_DIR$HOUSE$HOUSE_UNIT), ABONENT INDEX (FK_DIR$ABONENT$ABONENT_HOUSE)), DEVIANT_BEH INDEX (PK_DIR$ABONENT$DEVIANT_BEH))