Ask a Question
x

Choose Country Code

x

Direction

x

Ask a Question

  • Ask a Question
  • Scan a Question
  • Post MCQ
  • Note: File extension must be of jpg, jpeg, png, bmp format and file size must not exceed 5 MB
x

Ask a Question

x

Hire a Tutor

Answers and Solutions

What's Your Question?
Answer
An execution plan is a system view for the user of how the sql engine is internally processing a query . It consists of how different tables are being accessed, how looping operations are happening over datasets, how indexes are being used by the engine to execute the query etc. You would use an execution plan when you wish to gather information regarding the internal execution process of a query. This is generally done when we are not satisfied with the performance of a query in terms of resource usage, run time etc. You can view the execution plan using the dbms_xplan.display function. Alternatively you can view the system table plan_table to view execution plan.

Post Answer and Earn Credit Points

Get 5 credit points for each correct answer. The best one gets 25 in all.

Post Answer