Interested to Buy Any Domain ? << Click Here >> for more details...
Is there any advantage to denormalizing DB2 tables?
- 1 Answers
- 6651 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 the default page size of buffer pools?
How to connect to db2 database from windows command line?
What is access path in db2?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
Is db2 a mainframe?
How can you find out the # of rows updated after an update statement?
How do I import a csv file into db2?
wht is d/f between union and joins ?
How do you retrieve the data from a nullable column?
What is the physical storage length of timestamp data type?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
COBOL 
