When would you prefer to use VARCHAR?

Question Posted / guest

3 Answers
6324 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

When would you prefer to use VARCHAR?..

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

When would you prefer to use VARCHAR?..

Answer / sunil1405

when u declare a column with 10 bytes and only the field is
using 6bytes of storage , the balance 4 bytes will be
reclaimed ie its not wasted.

Is This Answer Correct ?

6 Yes

2 No

When would you prefer to use VARCHAR?..

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

Post New Answer