How Would You Go About Generating An Explain Plan?

1.	How Would You Go About Generating An Explain Plan?
Answer» CREATE a PLAN table with utlxplan.SQL. Use the EXPLAIN plan SET statement_id = ‘tst1’ into plan_table for a SQL statement Look at the explain plan with utlxplp.sql or utlxpls.sql Create a plan table with utlxplan.sql. Use the explain plan set statement_id = ‘tst1’ into plan_table for a SQL statement Look at the explain plan with utlxplp.sql or utlxpls.sql

Answer»

CREATE a PLAN table with utlxplan.SQL.
Use the EXPLAIN plan SET statement_id = ‘tst1’ into plan_table for a SQL statement
Look at the explain plan with utlxplp.sql or utlxpls.sql

Create a plan table with utlxplan.sql.
Use the explain plan set statement_id = ‘tst1’ into plan_table for a SQL statement
Look at the explain plan with utlxplp.sql or utlxpls.sql

Discussion

No Comment Found

Related InterviewSolutions

Name Two Files Used For Network Connection To A Database.
How Can You Gather Statistics On A Table?
You Have Just Compiled A Pl/sql Package But Got Errors, How Would You View The Errors?
Explain What Partitioning Is And What Its Benefit Is.
How Can You Rebuild An Index?
How Would You Determine Who Has Added A Row To A Table?
What View Would You Use To Determine Free Space In A Tablespace?
What View Would You Use To Look At The Size Of A Data File?
How Do You Resize A Data File?
How Do You Add A Data File To A Tablespace?

How Would You Go About Generating An Explain Plan?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment