This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Hi all! I have the following: SELECT pre.id_preaviso, pre.num_preaviso, TO_CHAR(pre.f_inip,'dd/mm/yyyy') f_inip, TO_CHAR(pre.f_presentacion,'dd/mm/yyyy') f_presentacion, c.nss, pre.nom_centro, pre.id_via, pre.via_nombre, pre.via_num, pre.via_num_bis, pre.via_escalera, pre.via_planta, pre.via_puerta, pre.localidad, pre.rama,pre.autonomia, pre.provincia,pre.municipio,pre.comarca,pre.delegacion,pre.sector,pre.subsector, ap.id_acta FROM preavisos pre,centros c, actas_preavisos ap WHERE (ap.id_preaviso(+) = pre.id_preaviso) AND (pre.id_centro = c.id_centro) AND pre.num_preaviso IS NULL AND ROWNUM <= 1001 How could I make (ap.id_preaviso(+) = pre.id_preaviso) in a different way, faster?
kusturica, Please take another look at the JavaRanch Naming Policy. We'd like to have you continue posting here, so please update your display name. You can do so here.
Joined: Mar 25, 2001
Originally posted by kusturica: How could I make (ap.id_preaviso(+) = pre.id_preaviso) in a different way, faster?
I'm not sure what you're asking. If you're talking about performance tuning, then I'm the wrong guy to respond. If your query needs to have the outer join in it to retrieve the appropriate data, then I don't see much alternative. [ October 01, 2002: Message edited by: Michael Matola ]