var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
as explain plan shows the graph model which says table scan indexe scan
hash join, nested joins, merge joins
can a dba make the optimizer choose the join methods or its completely depends upon optimizer
The optimizer picks the access plan, and there is not much you can do about it. The best you can do is to provide the optimal indexes for the queries. You can influence the optimizer by how the queries are written.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors