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 ole db ado?
Explain phantom deadlock?
can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance
i have windows-xp processor with P4 system. whenever I tried to download foxpro for windows 2.6 on windows XP, my operating system failed to install foxpro for windows 2.6.please. how could i download , install & run foxpro for windows 2.6 easily on windows XP ?
What are the tools used for backup and ticketing?
Define stored procedure?
Write a query to retrieve for many to many relationships?
Explain database partitioning. What is its importance?
What is aws documentdb?
Can a database table exist without a primary key?
Differentiate between extension & intension?
A design problem was given in which I was supposed to make a design for the data base for a given problem.
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)