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
what is rcp,if rcp disabled what happen?
How does database replication work?
What is ole db source in ssis?
give a simple example of physical and logical data independence
When should you not use firebase?
What is the DIF format and when we will use in teradata
How heap is implemented in database?
Explain phantom deadlock?
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
Can a database table exist without a primary key?
What is the difference between data source and database?
A design problem was given in which I was supposed to make a design for the data base for a given problem.
where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it
If the master device is full, how do I make the master database bigger?
What is the difference between a stored procedure and a query?