Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

interview

home / developersection / interviews / what is explain?
Ask Question
Varun Agrawal
Varun Agrawal

Other

Message

2 Answers

satish yedida
satish yedida 27 Dec 2012
Report Abuse

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.

Varun Agrawal
Varun Agrawal 28 Mar 2011
Report Abuse
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 ).
MindStick Training