Interview Questions   Tutorials   Discussions   Programs   

DB2 - What are the disadvantages of using VARCHAR?

asked mar August 3, 2014 07:19 AM  

What are the disadvantages of using VARCHAR?


1 Answers

answered By Mswami   0  
Disadvantages of using VARCHAR:

  • Can lead to high space utilization if most of the values are close to maximum.
  • Positioning of VARCHAR column has to be done carefully as it has performance implications.
  • Relocation of rows to different pages can lead to more I/Os on retrieval.
   add comment

Your answer

Join with account you already have



 Write A Tutorials
Online-Classroom Classes

  1 person following this question

  1 person following this tag

  Question tags

Asked 2 years and 3 months ago ago
Number of Views -392
Number of Answers -1
Last updated
3 years and 4 months ago ago

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!