Interview
    C#
    VB.Net
    VC++
    ASP.Net
    ADO.Net
    .Net Framework
    Silverlight
    WPF(Windows Presentation Foundation)/XAML
    WCF(Windows Communication Foundation)
    Java
    PHP
    AJAX
    Assembly
    XML
    Wireless/Mobile Development
    Cold Fusion
    MSSQL Server 2000/2005/2008/2012
    MYSQL
    DB2
    MS Access
    Java Script
    VB Script
    JQuery
    Testing
    BlackBox Testing
    WhiteBox Testing
    OOPS
    SharePoint
    ASP.NET MVC
    HTML5
    CSS/CSS3
    IIS 7
    Windows 8
    Google API
    Facebook API
    Twitter API
    Android Programming
    iPhone/iPad Programming
    Windows Phone Programming
    Json
Follow Us
Follow _MindStick_ on Twitter View MindStick Software's LinkedIn profile View MindStick Software's Facebook profile
Advertisement
Advertise with Us
Mindstick
Article Article  Forum Forum  Blog Blog  Quiz Quiz  Beginner Beginner  Careers Careers  Contact Contact  Login Login  
Home | Product | Services | About Us | Interview | DeveloperSection | Submit Question | Search 
Report Abuse Form
Reason:    
 
Interview
Home >> DB2 >> What is EXPLAIN?

What is EXPLAIN?

Posted By Varun Agrawal on 3/28/2011
Views: 319
Major Category: Database
Sub Category: DB2
Total Answer 2
User Information Answer
• Varun Agrawal
Posted Date 3/28/2011
EXPLAIN is used to display the access path as determined by the optimizer for a SQL statement. It can be used in SPUFI (for single SQL statement ) or in BIND step (for embedded SQL ).

Report Abuse

satish yedida
Posted Date 12/27/2012

Addition to Varun:  Explain utility using several  tables for storing accesspath information. The main tables are :

1. Plan table : It stores the access path information.

2. Dsn statement table : It stores cost estimation information.

3. Dsn function table : It stores user defined function if explain using such functions.


Report Abuse

Report Abuse Form
Reason:    
 
Total Online Users: 4751
Advertisement
dudelabs
Advertise with Us
  
Copyright © 2013MindStick. All Rights Reserved.