-
What is explain in teradata?
What is explain and how does it work?
Read Best Answer
Editorial / Best Answer
Madhulathamadduri- Member Since Jan-2010 | Apr 15th, 2011
The EXPLAIN modifier preceding an SQL statement generates an
English translation of the optimizer’s plan. It is fully parsed and
optimized, but not executed.
EXPLAIN returns:
Text showing how a statement will be processed (a plan).
An estimate of how many rows will be involved.
A relative cost of the request (in units of time).
This information is useful for:
• Predicting row counts.
• Predicting performance.
• Testing queries before production.
• Analyzing various approaches to a problem.
EXPLAIN may also be accessed using Teradata Visual Explain.senthang
- Jun 22nd, 2011
1. English version on optimizer plan2. to identify the objects used and kind of locks applied on those objects3. to identify the number of amp operation eg. single ot group amp4. to identify the data ...
yuvaevergreen
- Jun 6th, 2011
Explain statement generally gives the step by step analysis of the queries being executed in the database. It is the plan prepared by PE dispatched to the amps. It could also identify intermediate sp...
Read Best Answer
Ans