Re:

Thu, 09 Nov 2006 08:25:35 -0800 

ðÒÁ×ÄÁ × ÎÅËÏÔÏÒÙÈ ÓÌÕÞÁÑÈ ÔÙ ÐÒÁ×, ÅÓÌÉ ÍÅÌËÉÅ ÚÁÐÒÏÓÙ:

úÁÐÒÏÓ
     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)

Ответить