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
- 4717 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
where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it
How do you pass parameter in stored procedure?
Explain file manager?
what is rcp,if rcp disabled what happen?
Explain inner and outer joins with examples.
What is a database string?
What are indexes in oracle?
What is the difference between database and server?
What happens when shared and exclusive locks are applied on data item?
What is the best database?
Display the employees whose salary is less than average salary.
how can we view column head in first page but not in remaining pages?
Why do we need distributed database?
List the properties of a transaction.
What are the disadvantages of views in a database?
