Teradata Question:
Download Questions PDF

What is explain and how does it work?

Answer:

The 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.

Download Teradata Interview Questions And Answers PDF

Previous QuestionNext Question
What is an optimization and performance tuning and how does it really work in practical projects?What are the enhanced features in Teradata V2R5 and V2R6?