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 / akoman
D) EXPLAIN
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is ole db ado?
How many types of locks are present in a database?
what is data access layer?
How do you pass parameter in stored procedure?
What is a database lookup?
What is a trace file?
What is dialect in database?
Why do we need distributed database?
What is ole db source in ssis?
What the various ways to tune a teradata query
What is relational database with example?
Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it
Under which circumstance should you create an index on a table?
give a simple example of physical and logical data independence
issues involved in modeling and building data werahouses