Interested to Buy Any Domain ? << Click Here >> for more details...
Is there any advantage to denormalizing DB2 tables?
- 1 Answers
- 6649 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
Describe major components of db2?
Explain correlated sub-queries.
What is syscat in db2?
What parameters are used to control the free space in DB2?
What is the purpose of rollback and commit?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is check constraint. Explain with example.
Define declaration generator (dclgen).
How do I delete a column in db2?
What is the meaning concurrency in the db2 database?
What is runstats and reorg in db2?
What is explain plan in db2?
What are db2 tables?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is check constraint in db2?
