It's hard to give a common suggestion which is suitable for all cases. We need to know the exact queries being executed.
Arul wrote: > Agreed Ralf... > Not all SubQueries can be replaced by Joins.. > Thats why we have planned for Temp Tables.. > Any ideas on it.. > > > ----- Original Message ----- > From: "Ralf Narozny" <[EMAIL PROTECTED]> > To: "Arul" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> > Sent: Wednesday, June 26, 2002 3:00 PM > Subject: Re: SubQueries and Temp Tables > > > >>Hiho hiho! >> >>Which joins could that be? I think most if not all subqueries should be >>replacable with joins. >> >>Greetings >> Ralf >> >>Arul wrote: >> >> >>>Hi All >>> >>>I am currently porting our application from Oracle to MySQL. >>>We have some subqueries in oracle which cannot be ported into MySQL.We >> > even > >>>tried some joins which didnt work out.. >>> >>>So Could anyone throw some light on Temporary tables.Is this the right >> > way > >>>to do it.. >>> >>>Since our main query is dependent on the inner query we thought we could >>>run >>>the inner queryfirst and create a temp table.Then we could have a join >>>between the main table and the inner table. >>> >>>Is this advisable.. >>> >>>Any other better options? >>> >>> >>> >> >>-- >>Ralf Narozny >>Splendid Internet GmbH >>Skandinaviendamm 212, 24109 Kiel, Germany >>fon: +49 431 660 97 0, fax: +49 431 660 97 20 >>mailto:[EMAIL PROTECTED], http://www.splendid.de >> >> >> > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Alexander Barkov <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia <___/ www.mysql.com +7-902-856-80-21 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php