Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5644 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 are database connection details?
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
Define stored procedure?
What is the use of graph database?
how can we view column head in first page but not in remaining pages?
give a simple example of physical and logical data independence
Explain artificial key?
How does non-cluster index functions?
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
List the properties of a transaction.
What is the role of driver manager?
WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?
What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?
After normalization, what are the conditions which have to keep in mind to de-normalize it?
What is database server and how it works?
