Describes the examples of EXPLAIN in valid teradata database

Describes the examples of EXPLAIN in valid teradata database.

E

Expert

Verified

The given is an example of it:-
• EXPLAIN choose last_name,first_name FROM workers;
• The EXPLAIN parses the SQL statement other than does not execute this.
• It provides the designer along with an "execution stratergy".
• The execution strategy gives what an optimizer does but not why this chooses them.
• The EXPLAIN feature is used to analyze all complex and joins queries.

   Related Questions in Database Management System

2015 ┬ęTutorsGlobe All rights reserved. TutorsGlobe Rated 4.8/5 based on 34139 reviews.