Answer Posted / vamsikrishnamraju
Calculates statistics on the database to determine if
tables or indexes, or both, need to be reorganized or
cleaned up.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Explain the benefits you can get from mainframe connect?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How to check sequence on a table in db2?
define clustering index.
What is db2 connect?
What is buffer pool?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How many databases can be created inside an instance in db2 ?
What is ibm db2 used for?
What are the benefits of using the db2 database?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Why do we use cursor?
What is blu acceleration in db2?
How to connect to db2 database from windows command line?
What is the information associated with sysibm.syslinks table?