val02 Programmer Jul 29, 2002 5 IN Hi All I am learning DB2, I want to know is there is anything similar to Explain plan in Oracle, which can be used to view the statistics for the query like..physical read, sorts, whether query is using indexes etc... Thanks and Regards ValSort...
the execution plan is available for the entered statement and the explain plan button is selected in the query window. The logged in user also needs the necessary privileges, see the sections below for more information about privileges. If you wish not to get the plan by default every time a...
If you see any good use of the feature, please blog about it. Your example “a screenshot with query just single child cursor” is just a toy example that has nothing to do with real business. Please, do that. I’ll be happy to learn something new. 2) It does NOT tell you the ...
Please direct questions about technical support or the Study.com website to customer support. Drop photo or image here to upload or select file Get Answer By submitting, I am agreeing to the Terms of Use and Honor Code. Already a member? Log i...
In addition to the row source tree, the plan table contains information about the following: Optimization, such as the cost and cardinality of each operation Partitioning, such as the set of accessed partitions Parallel execution, such as the distribution method of join inputs The EXPLAIN PLA...
next level of the query for processing. In this case it is the SELECT STATEMENT which is the top of the query. [CHOOSE] is an indication of the optimizer_goal for the query. This DOES NOT necessarily indicate that plan has actually used this goal. The only way to ...
About Database Specialists, Inc. Database Specialists, Inc. provides remote DBA services and onsite database support for your mission critical Oracle systems. Since 1995, we have been providing Oracle database consulting in Solaris, HP-UX, Linux, AIX, and Windows environments. We are DBAs, spea...