What is explain and how does it work?
Submitted by: AdministratorThe EXPLAIN facility is a teradata extension that provides you with an "ENGLISH" translation of the steps choosen by the optimizer to execute an SQL
statement.It may be used oin any valid teradata database with a preface called "EXPLAIN".
The following is an example:-
EXPLAIN select last_name,first_name FROM employees;
The EXPLAIN parses the SQL statement but does not execute it.
This provides the designer with an "execution stratergy".
The execution stratergy provides what an optimizer does but not why it choses them.
The EXPLAIN facility is used to analyze all joins and complex queries.
Submitted by: Administrator
statement.It may be used oin any valid teradata database with a preface called "EXPLAIN".
The following is an example:-
EXPLAIN select last_name,first_name FROM employees;
The EXPLAIN parses the SQL statement but does not execute it.
This provides the designer with an "execution stratergy".
The execution stratergy provides what an optimizer does but not why it choses them.
The EXPLAIN facility is used to analyze all joins and complex queries.
Submitted by: Administrator
Read Online Teradata Job Interview Questions And Answers
Top Teradata Questions
☺ | What is stored procedure in Teradata? |
☺ | What is the difference between start schma and Fsldm? |
☺ | What are the enhanced features in Teradata V2R5 and V2R6? |
☺ | How teradata makes sure that there are no duplicate rows being inserted when its a SET table? |
☺ | What is an optimization and performance tuning and how does it really work in practical projects? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |