* Eugene Fokin <elf@solvo.ru> [20.05.2003 18:38]:
> > (loads l JOIN (SELECT rcn_details.id, rcn_details.date_pour FROM rcn_details) r ON ((r.id = l.rcn_id)))
> >
Try changing the join above to:
loads l JOIN rcn_details r ON r.id = l.rcn_id
Also, give the full description of fields, involved in your
load_rcn_id_idx and rcn_detail_idx indicies.
--
Victor Yegorov