Hi, I've recently commissioned a hosted system from a developer who has recommended using J2EE and Oracle. Their J2EE system is quite slick and works very well in preproduction. It uses annotations to generate the Oracle tables on the fly during deployment. On examination of the table structures that it's generated though, it's defaulted all of the VARCHAR2 definitions to 255 characters. On asking...

kailasTile

 Profile Answers by kailasTile Questions by kailasTile

• Dec 18th, 2007

Changing VARCHAR2(255) to precise required width is good table design. Though it will not improve performance as such.

Answer Question  Select Best Answer