Update :
My query SELECT * FROM v_actor JOIN f_intervenant_ref ON (actor_id = ir_actor_id) WHERE ir_dos_id = '5226' took 7
secs.
If I substitute the _RETURN rule for the view and add the above join, it takes 31 ms.
Mark Watson
Service au client - R&D
Tél. 418 659-7272 ou 1 888 692-1050
www.jurisconcept.ca