Interested to Buy Any Domain ? << Click Here >> for more details...
Is there any advantage to denormalizing DB2 tables?
- 1 Answers
- 6622 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 |
What is ibm db2 used for?
What is concurrency in db2?
What does sqlcabc has?
wht is d/f between union and joins ?
I use CS and update a page. Will the lock be released after I am done with that page?
How do I optimize a query in db2?
How can you quickly find out the # of rows updated after an update statement?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
What is the advantage in De-normalizing tables in DB2?
How do you stop a db2 database in linux?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
Explain the use of the WHERE clause.
COBOL 
