Is there any advantage to denormalizing DB2 tables?
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 |
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
What is COPY PENDING status?
What is meant by explain?
What are the 4 environments which can access DB2 ?
What is rct?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is QUIESCE?
What happens to the PLAN if index used by it is dropped?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is database manager in db2?
What is a dbrm in db2?
Explain transactions, commits and rollbacks in DB2.