Wednesday, November 27, 2013

What are the 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.

0 comments:

Post a Comment