Generating an EXPLAIN plan
How would you go about generating an EXPLAIN plan?
Â
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
Recent Articles
-
What is native?
What is native? Native is a Java keyword that is used in method declarations to specify that the method is not implemented in the same Java source file, but rather in another language. Read More...
-
What is multithreaded?
What is multithreaded? Describes a program that is designed to have parts of its code execute concurrently. Read More...
-
What is method?
What is method? A function defined in a class. See also instance method, class method. Unless specified otherwise, a method is not static. Read More...
-
What is member?
What is member? A field or method of a class. Unless specified otherwise, a member is not static. Read More...
-
What is long?
What is long? A Java keyword used to define a variable of type long. Read More...