Re: [SQL] combination of function to simple query makes query slow

Some more information: An EXPLAIN of the following query my_db=> explain select m1.object1_id, m1.object2_id, m2.object1_id, m2.object2_id my_db-> from c_mappings m1, c_mappings m2 my_db-> where m1.object1_id = 16575564 my_db-> and m2.object1_id in (select aliases_of(m1.object2_id)); gives

Re: [SQL] combination of function to simple query makes query slow

On 10/3/05, jan aerts (RI) <[EMAIL PROTECTED]> wrote: > Some more information: > > An EXPLAIN of the following query > my_db=> explain select m1.object1_id, m1.object2_id, m2.object1_id, > m2.object2_id > my_db-> from c_mappings m1, c_mappings m2 > my_db-> where m1.object1_id = 16575564 > my_db