Monday, November 25, 2013

What are the disadvantages of using VARCHAR?

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

0 comments:

Post a Comment