Interview Questions   Tutorials   Discussions   Programs   

DB2 - What are the disadvantages of using VARCHAR?




392
views
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.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  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!

Alert