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 data set ?
What are the various ways to execute a query in teradata?
What are the types of indexes that are present inside a database?
Explain the table term used in database.
How can we join three tables in SQL server 2000
plz suggest me the books for the preparation of NIC written exam.
Its possible to use auto increment in oracle or not? If no means why?
List some advantages of dbms.
What is Data Modelling?
Does aggregate and fact tables gets populated from transactional data with only diffrence in there granularity? Please clarify?
give a simple example of physical and logical data independence
Explain about ur projets on teradata???
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)