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
Define buffer pool.
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is image copy in db2?
is it compulsory commitment control in journal?
Is db2 a programming language?
What is the advantage in De-normalizing tables in DB2?
How is the value function used?
What does db2 stand for?
What does sqlcabc has?
Why select is not preferred in embedded sql programs?
What is declare cursor?
What are the contents of a dclmgen?
How does coalesce work?
What is bind and rebind in db2?
What is the purpose of using commit?
