Interested to Buy Any Domain ? << Click Here >> for more details...
When would you prefer to use VARCHAR?
- 3 Answers
- 7567 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 spufi and qmf?
What is the database descriptor?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
What is alias in db2?
Mention the downsides of page level lock.
What does CURRENTDATA option in bind indicate
What is the purpose of using commit?
what are the max. & min. no. of partitions allowed in a partition tablespace?
What is a synonym ?
what happend with out using Commit,when closing cursor and program?
What is rct?
COBOL 
