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
5777 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 three commands cause a transaction to end?

1062

What is a trace file?

1067

What happens when shared and exclusive locks are applied on data item?

1036

Differentiate between extension & intension?

1424

How does database replication work?

994

What is the concept of Virtual field?

2054

Should I store images in database?

1026

What is the difference between data source and database?

1083

What is a database lookup?

1087

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

2506

How to produce such kind of file?

1103

How is image stored in database?

1037

What are the tools used for backup and ticketing?

997

How many types of normalization? What is the use of it?

1132

What are indexes in oracle?

1088