When would you prefer to use VARCHAR?
- 3 Answers
- 6339 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 |
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
How to execute stored procedures?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
How is a typical db2 batch pgm executed?
How do I change the column size in db2?
how to u check the query is executing or not ?where will u check for sqlcode ?
What are foreign keys in db2?
What is the physical storage length of timestamp data type?
What is meant by a unit of recovery?
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
what is the process of precompiler?
Can any one tell me about Restart logic in DB2.
COBOL 
