Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / s
RUNSTATS does not reclaim space nor orders records, its the
REORG utility that will reorganize the data records.
RUNSTATS collects statistics about the data in the table
like, cardinality statistics, frequency statistics that
will be used by the optimizer to determine a good access
path.
| Is This Answer Correct ? | 30 Yes | 3 No |
Post New Answer View All Answers
How is the value function used?
Explain the function done by data manager?
How connect db2 database to datastage?
can we view the access paths created by dbrm ? how ? thx
Explain about rct in db2?
What is buffer pool in the db2 database?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Which component is used to execute the sql statements?
Define check constraint.
Which is faster delete or truncate?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Name the lockable units in DB2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
