Interested to Buy Any Domain ? << Click Here >> for more details...
Is there any advantage to denormalizing DB2 tables?
- 1 Answers
- 6720 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
What does db2 blu stand for?
i want to maintain uniqueness on pdf without make lf??????????
What is image copy in db2?
How to restart a DB2 program?
How can we read records for specific member in CL? AND rpg?
How do I add a column in db2?
Outputs of explain are with matchcols = 0. What does this signify?
If I have a view which is a join of two or more tables, can this view be updateable?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is the max length of sqlca?
What is package in db2 mainframe?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is buffer pool?
How to connect to db2 database from windows command line?
