Interested to Buy Any Domain ? << Click Here >> for more details...
When would you prefer to use VARCHAR?
- 3 Answers
- 7841 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 |
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
How many buffer pools are there in DB2?
What are data types?
What is view db2?
How to insert more than one record using insert?
Is db2 free?
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
What is the function of the Data Manager?
Once you create a view, where would information about the view be stored?
Explain about open switch business continuity software?
What DB2 Catalog column tell you when an index needs table reorganized ?
How would you find out the total number of rows in a db2 table?
COBOL 
