Explain explain will give the optimizer plan for the query explain se

utility used to obtain inform regarding the optimizes
choice of access strategy for SQL stmts
A) LOAD
B) REORG
C) COPY
D) EXPLAIN

Question Posted / raj kumar

2 Answers
5796 Views
Accenture, I also Faced
E-Mail Answers

Answer Posted / raj kumar

Explain

explain will give the optimizer plan for the query

explain select * from .......etc

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?

2510

How to do Data integrity testing? Who does this testing (Developer or tester)?

2108

Which is the best graph database?

956

What is a reference table in database?

1024

What is the role of driver manager?

1014

What are the most common databases?

971

What is a sequence? Explain it with one example?

1191

What are different types of joins used in?

1110

what is transaction state, buffer management, shadow paging

3457

What is a database lookup?

1095

Difference between sql and mysql?

2093

What are the various ways to execute a query in teradata?

2614

What is database collection?

1015

What is ole db source in ssis?

1003

Can a database table exist without a primary key?

952