2.4k questions

2.4k answers

97.9k users

4 Online Users
1 Member 3 Guest
Online Members
Today Visits : 1587
Yesterday Visits : 1686
Total Visits : 2423849



Dear All, These are my answers from Quora and primarily Google; please check the answer and from others sites; the answers are free and without any liability.To make a decision, write down all of the positives and negatives on a piece of paper.Thank you,

Elias Katsaniotis, MSc


Viktoria Katsanioti,




1 Answer

0 votes

This is a sort definition from Google:

It is best to use EXPLAIN PLAN to determine an access plan, and then later prove that it is the optimal plan through testing. When evaluating a plan, examine the statement's actual resource consumption. Use Oracle Trace or the SQL trace facility and TKPROF to examine individual SQL statement performance.

You must perform some tests when the server has many or max users and with the testing you are going to conclude for the value of the plan, The env is rarely static, you have to follow the evolution of the DB.

by (95.8k points)