When would you prefer to use VARCHAR?
- 3 Answers
- 6349 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 |
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
What are catalog tables in db2?
how to resolve -818 error. how to see timestamp token in load module and plan
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
what is Static and dynamic linking
What is copy pending and check pending in db2?
What is db2 instance?
Can we install 2 different versions of Db2 on same mainframe?
How do I add a column to an existing table in db2?
How do I delete a table in database?
wt is view ? wht r the restrictions for view ?
What is correlation names?
COBOL 
