Is there any advantage to denormalizing DB2 tables?
Answer Posted / 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 View All Answers
What types of tables are there in the db2 database?
What is coalesce in db2?
What is lock escalation in db2?
What is the use of reorg in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is the role of data manager in the db2 database?
What are the different types of base tables?
What is the physical storage length of date data type?
What are the various data types available in db2?
How many databases can be created inside an instance in db2 ?
How to find schema of a table in db2?
List down the types of triggers in the db2 database?
What is the maximum No of rows per page?
What is dbrm? What it contains? When it will be created?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?