Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Databases Programming Interviews:BtrieveClipperData ModelingData StructuresDatabase AdministrationDatabase Administrator (DBA)Database AnalystDatabase DeveloperDB DevelopmentEDI/Data Integration ExpertFirebirdHierarchicalIBM DB2InformixJava DatabaseMariaDBMicrosoft Access DeveloperMongoDBMS SQL ServerMySQL ProgrammingNetworkNoSQLObject RelationalPostgrePostgreSQLProgressRDBMSRelationalSQLSQL AdministratorSQL and PL/SQLSQL Notification ServicesSQL server 2008SSRSStored ProcedureSybaseTeradata
Copyright © 2018. All Rights Reserved
Teradata Interview Question:
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
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.