1.

What Are The Factors Considered By A Physical Query/execution Plan?

Answer»

Following factors are considered by a physical QUERY or an execution plan:

  1. The VARIOUS operations(eg:joins) to be PERFORMED during the query.
  2. The ORDER in which the operations are performed.
  3. The algorithm to be used for performing each operation.
  4. The best WAY to retrieve data from disk or memory.
  5. The best way to pass data from one operation to another during the query.

Following factors are considered by a physical query or an execution plan:



Discussion

No Comment Found