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?

Answers were Sorted based on User's Feedback



What are the disadvantages of using VARCHAR?..

Answer / s

1.Additional 2 byte length indicator is stored along with
the VARCHAR column.
2.It can potentialy affect the amount of logging when the
row with VARCHAR column is updated.
3. The placement of the VARCHAR column in a DB2 table has
performance impact. DB2 has to calculate the offset of the
the column that occurs after the VARCHAR each time the
column is accessed that increases the CPU consumption.
Atleast 5-15 instructions are executed per column.

Is This Answer Correct ?    9 Yes 0 No

What are the disadvantages of using VARCHAR?..

Answer / vinod babu

Varchar data types have to handle carefully. otherwise high
chances to get -311 error during the process.

Is This Answer Correct ?    4 Yes 2 No

What are the disadvantages of using VARCHAR?..

Answer / 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

More DB2 Interview Questions

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  


can any body explain about plan and pakage in detail....

2 Answers   HSBC, IBM,


how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers   UST,


When is the skeleton cursor table created?

1 Answers  


Write a query to retrive partial string.

2 Answers  


database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

1 Answers  


db2 restart logic ?

1 Answers   DELL, HTC, UHG,


db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2

9 Answers   TCS,


which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,


cobol-db2 runjcl please?

2 Answers   DELL,


how do you resolve -805?

3 Answers   HCL,


What will happen, while trying to close the closed cursor.

1 Answers  


Categories