Re: Oracle Query optimizer
From: John Dennis <jdennis_at_netcom.com>
Date: Fri, 8 Jul 1994 01:56:07 GMT
Message-ID: <jdennisCsLMpJ.2tw_at_netcom.com>
Date: Fri, 8 Jul 1994 01:56:07 GMT
Message-ID: <jdennisCsLMpJ.2tw_at_netcom.com>
Oracle 7 uses a cost-based optimizer. This has *basically* got rid of the need to know the order of the tables on a join clause (etc). However, ignorant users can still write some nasty queries (i.e. using HAVING or nesting a query when it is not necessary)
John Received on Fri Jul 08 1994 - 03:56:07 CEST