Interested to Buy Any Domain ? << Click Here >> for more details...
Is there any advantage to denormalizing DB2 tables?
- 1 Answers
- 6663 Views
- I also Faced
- E-Mail Answers
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 |
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
What is the role of union all and union
Compare a subselect to a join?
How to test SQL -911 error while developing COB-DB2 program
What is a db2 cursor?
What is meant by the attachment facility?
What is the STOSPACE Utility used for?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
what is datacom db?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
What are the three DB2 date and time data types and their associated functions?
How and when does the db2 enforces the unique key?
COBOL 
