Re: subquery vs. join?
From my experience, whenever you can use a join instead of a subquery (or a where clause), use a join!! And make sure that the biggest tables are used last, whenever possible. I have experienced this on a database with more than 260,000 records (average size), and my queries ended up saving near 5 seconds over queries that could take up about 5 to 6 seconds (which is a HUGE performance gain)!!
Subject
Views
Written By
Posted
20542
December 03, 2004 02:52AM
Re: subquery vs. join?
7183
December 05, 2004 03:03AM
6000
December 05, 2004 07:52PM
6214
January 20, 2005 03:48AM
5354
January 20, 2005 06:52AM
4717
January 21, 2005 11:43PM
4903
January 21, 2005 11:38PM
3919
January 20, 2005 04:41PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.