I think Oracle Database and Derby behavior will be same. CHAR(size) will preallocate size*characters in database page/block whereas VARCHAR(size) will not. Maybe if you give us any hint what are you trying to do we could help better. Peter
On Mon, Apr 5, 2010 at 3:41 PM, Mamatha Kodigehalli Venkatesh <[email protected]> wrote: > Hello, > > > > Please let us know what will be the performance impact when I use VarChar > (4000) instead of Char. > > I have found that the inserts to the table which contains this change are > very slow… > > > > But on oracle, there is not much of impact on this. > > > > Based on the business requirement I need to use VarChar. > > > > Any suggestions will be of great help. > > > > Thanks > > Mamatha > > > >
