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...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

Is there any advantage to denormalizing DB2 tables?

Question Posted / guest


Is there any advantage to denormalizing DB2 tables?..

Answer / s

Yes denormalization is done performance reasons.
Normalization will keep the related data in separate
tables. In order to get the data from the tables, DB2 uses
JOIN which could be resource intensive depending on the
number of tables used in the join and the size of the table.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More DB2 Interview Questions

What information is contained in a SYSCOPY entry?

2 Answers  

Can you access the DB2 Directory table using SQL?

3 Answers  

What is schema in db2?

0 Answers  

What is the difference between Primary key and unique index?

6 Answers  

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  

What is the use of db2?

0 Answers  

Why do we need reorg in db2?

0 Answers  

What is the error code -803 ?

3 Answers  

What is multi row fetch in db2?

0 Answers  

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  

Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers  

what is a corelated subquerry?

0 Answers   IBM,

For more DB2 Interview Questions Click Here
Categories