ðÒÁ×ÄÁ × ÎÅËÏÔÏÒÙÈ ÓÌÕÞÁÑÈ ÔÙ ÐÒÁ×, ÅÓÌÉ ÍÅÌËÉÅ ÚÁÐÒÏÓÙ:
úÁÐÒÏÓ
select p.name,p.fullname,p.description
from products p,
(select id from recurs_groups(0)) rg
where rg.id=p.id_group
PLAN JOIN (GROUPS INDEX (RDB$PRIMARY7), RECURS_GROUPS NATURAL)(GROUPS INDEX
(GROUPS_IDX__PARENT_NAME))(P INDEX (RDB$FOREIGN43))
Ñ×ÎÏ ÌÕÞÛÅ ÞÅÍ
select p.name,p.fullname,p.description
from products p
where exists (select id from recurs_groups(0) where p.id_group=id)
PLAN (GROUPS INDEX (RDB$PRIMARY7))(RECURS_GROUPS NATURAL)(GROUPS INDEX
(GROUPS_IDX__PARENT_NAME))
PLAN (P NATURAL)
