utility used to obtain inform regarding the optimizes
choice of access strategy for SQL stmts
A) LOAD
B) REORG
C) COPY
D) EXPLAIN
- 2 Answers
- 4509 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
What is the candidate key used for?
What are the various ways to execute a query in teradata?
What is ase database?
How to do Data integrity testing? Who does this testing (Developer or tester)?
Explain file manager?
What is database schema name?
HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?
What is redis good for?
Write a query to retrieve for many to many relationships?
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
What do you mean by database?
what is data access layer?
List various types of log-based recovery in DBMS.
How do you connect to a database?
