Explain EXPLAIN in Sql

Posted by Alok under Interview Questions on 12/14/2011 | Points: 10 | Views : 2451 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

WHAT is 'EXPLAIN' in SQL..
plz reply..

Thanks & Regards,
Alokssm

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts