Interested to Buy Any Domain ? << Click Here >> for more details...
Is there any advantage to denormalizing DB2 tables?
- 1 Answers
- 6554 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
How to restart a DB2 program?
Explain packages.
What is reorg?
What is buffer pool?
What is the result of open cursor statement?
Why do we need reorg in db2?
What is catalog database in db2?
what is diffrence b/w file-aid tool and file-aid utility???
Outputs of explain are with matchcols = 0. What does this signify?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is the use of commit in db2?
Explain the contention situations caused by locks?
How to create backup table in db2?
What is ibm db2 client?
How to check sequence on a table in db2?
