Explain EXPLAIN in Sql

Posted by Alok under Interview Questions on 12/14/2011 | Points: 10 | Views : 1317 | Status : [Member] | Replies : 1
WHAT is 'EXPLAIN' in SQL..
plz reply..

Thanks & Regards,
Alokssm



Responses

Posted by: Gow.net on: 12/15/2011 [Member] Starter | Points: 25

Up
0
Down
Name

EXPLAIN -- show the execution plan of a statement
Synopsis

EXPLAIN [ ANALYZE ] [ VERBOSE ] query

Inputs

ANALYZE
Flag to carry out the query and show actual run times.

VERBOSE
Flag to show detailed query plan dump.

query
Any query.

Outputs

Query plan
Explicit query plan from the PostgreSQL planner.

Note: Prior to PostgreSQL 7.3, the query plan was emitted in the form of a NOTICE message. Now it appears as a query result (formatted like a table with a single text column).
http://www.sql.org/sql-database/postgresql/manual/sql-explain.html


gowthaman8870226416

Alok, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response