Results 1 to 2 of 2

Thread: explain plan

  1. #1
    Join Date
    Oct 2007
    Posts
    246

    Unanswered: explain plan

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •