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 is bind and rebind in db2?
What is syscat in db2?
i want to maintain uniqueness on pdf without make lf??????????
Explain various types of locks in db2?
How do I add a column to a table in db2?
what is the sqlcode -501
How connect db2 database to datastage?
What is the use of value function?
What is database manager in db2?
What is db2 look?
Mention the various locks that are available in db2.
What r the comman abends in db2, jcl and cobol???????
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Explain what are the various isolation levels possible?
What are db2 tables?