Interested to Buy Any Domain ? << Click Here >> for more details...
When would you prefer to use VARCHAR?
- 3 Answers
- 7716 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 |
wht displays the number of times a query modified ?
What is the function of the Data Manager?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is UNION,UNION ALL?
What is catalog database in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is the syntax for FETCH in DB2 ?
How to resolve -502 sql code in DB2?
What is difference between rollback and commit?
Explain an outer join?
What is an inner join, and an outer join ?
COBOL 
