Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What are the disadvantages of using VARCHAR?

Answer Posted / s

When updating VARCHAR columns, the row may not fit on the
page anymore and a pointer to the new row is left in the
orginal space. Over time, there will be more relocated rows
that degrades performance.

Is This Answer Correct ?    6 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is null indicator in db2?

1120


What are the two types of logging in the db2 database? Explain them.

1081


What os does db2 run on?

994


What is the syntax for seeing the columns and data types of a table in the db2 database?

1172


What is syscat in db2?

1020


How can you do the explain of a dynamic sql statement?

1073


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1111


What are the contents of a dclmgen?

1135


How to connect to db2 database from windows command line?

1069


How do I delete a table in database?

1029


Who uses db2?

1056


What are the different types of base tables?

1100


What is the advantage in De-normalizing tables in DB2?

1184


What is db2 stogroup?

1167


What is the use of reorg in db2?

1089