Interested to Buy Any Domain ? << Click Here >> for more details...
Is there any advantage to denormalizing DB2 tables?
- 1 Answers
- 6623 Views
- I also Faced
- E-Mail Answers
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
List out the buffer pools in db2
How do I import a csv file into db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
what are bind concepts in db2 cobol?
What are the contents of a dclmgen?
What is ibm db2 client?
can we view the access paths created by dbrm ? how ? thx
Explain the function done by data manager?
What are the uses of db2 optimizer?
What is the use of predicate?
What is difference between alias and synonym in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is the difference between dbm cfg and db cfg file in db2 ?
What is multi row fetch in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
