Interested to Buy Any Domain ? << Click Here >> for more details...
Is there any advantage to denormalizing DB2 tables?
- 1 Answers
- 6635 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 |
How to fetch the last row from the table in SQL (db2)?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
What is difference between *omit and *nopass?
What is DB2 (IBM Database 2)?
What are union and union all?
How can we read records for specific member in CL? AND rpg?
What is the physical storage length of date data type?
Give a brief description of db2 isolation levels?
What is concurrency?
What is the difference between plan and package in db2?
what is REORG? what is the use?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
COBOL 
