Interested to Buy Any Domain ? << Click Here >> for more details...
Is there any advantage to denormalizing DB2 tables?
- 1 Answers
- 6726 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 |
Can you search give an array in the WHERE clause of a db2 query?
When DB2 connection fails, will online program work or give errors.
What is an access path?
What is db2 bind process?
What is meant by repeatable read?
What does runstats do in db2?
Explain about open switch business continuity software?
What do you mean by commit and rollback?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
What is a correlated sub query?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
What is the difference between db2 and oracle?
COBOL 
