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 |
Mention the definition of cobol in varchar field.
What is DCLGEN ?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
Is schema the same as database?
wt is view ? wht r the restrictions for view ?
What is host variable in db2 cobol?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
What is dbrm in db2 database?
What is an access path?
On which levels locks can be applied?
What is plan in cobol db2?