Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / s
The obvious benefit is savings in disk space. Thus reduced
row length means more rows per page which means lesser
getpages. Fewer getpages mean less locks hence less CPU
costs and less I/O. Use of VARCHAR reduces the number of
bytes passed between DB2 and application. There is a CPU
cost associated with each byte of data moved.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What do you mean by rollback?
What is meant by dclgen?
Can we update view in db2?
What are union and union all?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How will you return the number of records in table?
When do you specify the isolation level?
What is dclgen (declaration generator)?
What is a cursor in programming?
What is package in cobol db2?
Define buffer pool.
What is a storage group (stogroup)?
What is db2 plan table?
What is table space in db2?
Explain various types of locks in db2?
