utility used to obtain inform regarding the optimizes
choice of access strategy for SQL stmts
A) LOAD
B) REORG
C) COPY
D) EXPLAIN
Answers were Sorted based on User's Feedback
Answer / raj kumar
Explain
explain will give the optimizer plan for the query
explain select * from .......etc
| Is This Answer Correct ? | 2 Yes | 0 No |
What is difference between clustered, non-clustered and unique index?
Explain the record term used in database.
A design problem was given in which I was supposed to make a design for the data base for a given problem.
can we delete autodiff back up that we have set through sql server agent.
0 Answers Indian Web Technology,
What are the differences between Database Trigger and Integrity constraints ?
How do database connections work?
What do you mean by cluster and non cluster index?
What the various ways to tune a teradata query
What is a Transformation?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
How much does it cost to build a database?
what are different types of datasets? what are different characteristics or properties of those datasets? what are the advantages and disadvantages of each dataset on each other?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)