Interested to Buy Any Domain ? << Click Here >> for more details...
When would you prefer to use VARCHAR?
- 3 Answers
- 7691 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kums
Rather than storing the object in the data base, specify
the location of the object (image) by creating a column
with VARCHAR. This kind of approach may be used in web
technologies. pl correct if I'm wrong.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the difference between Primary key and unique index?
Why do we bind in db2?
What are the disadvantages of using VARCHAR?
Where besides the DB2 catalog is database object information stored by DB2?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
What is meant by union and union all?
What is runstats utility in db2?
What is difference between alias and synonym in db2?
What is the difference between group by and order by?
What are the benefits of using the db2 database?
What is null value in db2?
Mention the location where the output received from explain statement is stored.
COBOL 
