utility used to obtain inform regarding the optimizes
choice of access strategy for SQL stmts
A) LOAD
B) REORG
C) COPY
D) EXPLAIN
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
Explain partial key?
What is aws documentdb?
can u combine pipeline parallelism and partition parallalism? how and whan?
How do I manually create a database?
What are database connection details?
How many types of normalization? What is the use of it?
What are the disadvantages of views in a database?
Explain entity set?
What is Object Oriented model?
Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar
How to implement database security?
After normalization, what are the conditions which have to keep in mind to de-normalize it?
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
What is a driver in database?
What are different types of blocks used in stored procedure?