hi

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
regds
paul

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.

Andy