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
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is reorg and runstats in db2?
What is view db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Explain how can you do the explain of a dynamic sql statement?
Can you use max on a char column?
what is a corelated subquerry?
What is plan in cobol db2?
What is syscat in db2?
Which isolation level provides maximum concurrency?
What does reorg do in db2?
Mention the downsides of page level lock.
When do you specify the isolation level?
Why cursor is used in db2?
What are db2 objects?
