Oracle Implementation Plan

2010-03-09  来源:本站原创  分类:Database  人气:185 

Summary: SQLPLUS under the automatic display, look at their statements or implementation plan will be implemented. Especially in the implementation of the UPDATE / DELETE statement, please do note, ORACLE is the first implementation of the script also shows that implementation of the plan, even with set autotrace on traceonly explain;

Recommended at this time, or run EXPLAIN PLAN FOR PL / SQL and other third-party tools

3, the third tool of view the implementation plan

If the PL / SQL using select query execution plan display, which only need to enter SQL WINDOWS window query SQL statement, then select the button F5 or the menu TOOLSDD> Explain Plan button on the menu in the implementation of program window view of the statement execution plan.
Statement in TOAD SQL in the implementation of the current window, select the bottom of the page that you can view Explain PlanTAB statement to execute the implementation plan information.

set autotrace on explain;
explain plan for
select * from emp where

http://space.itpub.net/127656/viewspace-364817

相关文章
  • Oracle Implementation Plan Detailed 2011-05-06

    Oracle Implementation Plan Detailed --- Of: TTT BLOG This article addresses: http://blog.chinaunix.net/u3/107265/showart_2192657.html --- Description: Full details of this oracle concepts related to the implementation plan, access to the data access

  • ORACLE implementation plan of some basic concepts 2011-03-22

    ORACLE implementation plan of some basic concepts (1) One. Related Concepts Rowid concept: rowid is a pseudo-column, since it is pseudo column, this column is not user-defined, but the system itself to add the. For each table has a rowid pseudo-colum

  • ORACLE implementation plan of some basic concepts 2 2011-03-22

    ORACLE implementation plan of some basic concepts (2) III. The connection between the table Join an attempt to combine the two predicate table, one can only connect two tables, table join is also called table association. In the following description

  • Oracle: implementation plan: access path connection table, suggesting Statistical information bind variables 2011-09-09

    SQL execution: Analysis: Hard analysis, soft analysis Implementation Plan: access path (access path), table join (table join), statistics (statistics), bind variable (bind variable), tips (hints) ================================================== ===

  • Oracle Implementation Plan 2010-03-09

    Summary: SQLPLUS under the automatic display, look at their statements or implementation plan will be implemented. Especially in the implementation of the UPDATE / DELETE statement, please do note, ORACLE is the first implementation of the script als

  • Analysis of the implementation plan optimization SQL <3> ORACLE implementation plan (transfer) 2010-05-27

    Background: In order to better carry out the following elements we must understand some conceptual terms: Sql statement to not share the same The SQL statement parsing Zhong Fu (Yinweijiexi Caozuobijiao costs of resources, can cause performance degra

  • How to see Oracle implementation plan 2011-01-14

    oracle explain an implementation plan. Related Concepts 1 · rowid, pseudo-column: is the system to add their own, each table has a pseudo-column is not physically exist. It can not be modified, deleted, and added, rowid in the life cycle of the line

  • Oracle Implementation Plan (Explain Plan) Description 2011-07-07

    http://blog.csdn.net/tianlesoftware/article/details/5827245 http://blog.csdn.net/tianlesoftware/article/details/5826546 If you want to analyze the SQL performance on a particular issue, usually we have to look at the SQL execution plan to see each st

  • How to read ORACLE implementation plan 2011-08-11

    First, what is the implementation plan An explain plan is a representation of the access path that is taken when a query is executed within Oracle. Second, how to access data At the physical level Oracle reads blocks of data. The smallest amount of d

  • ORACLE Implementation Plan Analysis 2011-09-26

    ORACLE analysis of an implementation plan, what is the implementation plan An explain plan is a representation of the access path that is taken when a query is executed within Oracle. Second, how to access data At the physical level Oracle reads bloc

  • ORACLE SQL Optimization - ORACLE Implementation Plan 2010-03-16

    Last login: Mon Feb 8 14:13:19 2010 from 192.168.1.249 ipnet -Bash-3.00 $ -Bash-3.00 $ ipnet -Bash: ipnet: command not found -Bash-3.00 $ su - oracle Password: eastcsu: incorrect password -Bash-3.00 $ eastcom -Bash: eastcom: command not found -Bash-3

  • Oracle execution plan from the start view 2010-08-29

    Consider the following situation (1) If your data table to manage 40 million video information; (2) If you manage 10 million kinds of product data sheets; A simple paging query, you truly feel its efficiency over it? If users complain about slow resp

  • (Installed) oracle execution plan 2011-07-20

    One. Related Concepts Rowid concept Recursive Sql concept Predicate (verb) DRiving Table (table-driven) Probed Table (by probe table) Combination index (concatenated index) Selectivity (selectivity) II. oracle access to the data access methods 1) Ful

  • Oracle execution plan from the beginning to view 2010-08-29

    Consider the following scenario, (1) If your data tables to manage 30 million line of card user information; (2) If you manage 10 million kinds of product data sheets; A simple paging query, you truly felt it efficient? If users complain about slow r

  • Read oracle's implementation plan 2010-04-28

    Read oracle's implementation plan Implementation plan for beginners is usually more difficult to read, often reading the implementation plan from the inside out, starting from the operation of the deepest indentation. General principles: 1. First of

  • Analysis of the implementation plan optimization SQL <2> ORACLE optimizer (change) 2010-05-27

    Optimizer is sometimes called the query optimizer, which is affecting database query performance because the most important part, do not think that only the SELECT statement is the query. In fact, with any WHERE conditions DML (INSERT, UPDATE, DELETE

  • Oracle SQL with AutoTRACE analysis of the implementation plan 2010-09-06

    Turn http://hi.baidu.com/bystander1983/blog/item/d6c26a53fe457b040cf3e3cd.html * Environment: windowsXP + Oracle10gR2 * AutoTRACE is to analyze the SQL execution plan, the efficiency of a very simple and convenient tool * / AUTOTRACE is a function of

  • Why Oracle will sometimes use the index to find data? - Force Oracle to use the best "implementation plan" 2011-06-01

    [Abstract] you use SQL, a query to the database when you release, Oracle will be generated with an "implementation plan" that is, what kind of data that the statement will search through the implementation of the program. Search for program sele

  • Why Oracle will sometimes use the index to find data? - To force Oracle to use the best "implementation plan" 2011-06-01

    [Abstract] you use the SQL language, a query to the database release, Oracle will have with an "implementation plan", that is what the statement by the data search program execution. Search program selection is closely related to the Oracle opti

  • Oracle database implementation plan some basic concepts 2011-08-28

    Oracle database implementation plan some basic concepts One. Related Concepts Rowid concept: rowid is a pseudo-column, since it is pseudo-column, then this column is not user-defined, but the system of their own to add. For each table has a rowid pse