Results 1 to 6 of 6

Thread: Want to know about this term in SQL

  1. #1
    Contributing Member
    Join Date
    May 2006
    Answers
    71

    Want to know about this term in SQL

    What does the term explain plan in SQL query means. Has it got something to do with SQL optimization? If so can someone tell me the usage of this so that I can use it for optimizing my queries?


  2. #2
    Contributing Member
    Join Date
    May 2006
    Answers
    82

    Re: Want to know about this term in SQL

    explain plan in sql is used to explore an execution plan. If explain plan is used then Oracle will analyze the statement and fill a special table with the Execution plan for that statement which has details like whether index is used or not, if there are more than one index then which index is used for achieving good performance and so on.


  3. #3
    Contributing Member
    Join Date
    Jul 2006
    Answers
    76

    Re: Want to know about this term in SQL

    To add further to the explanation of timmy the syntax for explain plan usage in both the situations is given below:
    explain plan for your-precious-sql-statement;
    The above is a general syntax of explain plan statement.
    If one wants to write to a table the syntax used for explain plan statement is explain plan into table name for your-precious-sql-statement;


  4. #4
    Expert Member
    Join Date
    May 2006
    Answers
    114

    Re: Want to know about this term in SQL

    The discussion is a very useful one. It gave a detailed insight about the term plan in SQL.


  5. #5
    Junior Member
    Join Date
    Jun 2007
    Answers
    8

    Re: Want to know about this term in SQL

    Explain plan is to find the excution cost of a particular query.
    Independent of the sequencing of statments it gives the cost of a query in terms of time taken to execute the same.

    the explain plan changes if some conditions are changed in a Query and it gives the least cost of the query executed.


  6. #6
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Want to know about this term in SQL

    it shows the execution plan or the path followed by the optimizer to retrive the record. Here we can check wheather an index or a hint is being used or not by the optimizer.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact