Interested to Buy Any Domain ? << Click Here >> for more details...
What is denormalization and when would you go for it?
- 9 Answers
- 39375 Views
- NBP, I also Faced
- E-Mail Answers
Answer Posted / sd
Denormalization is introcution of controlled redundancy in
the database.
Use denormalization generally to optimize performace of
select query. to minimize joins used in the query.
| Is This Answer Correct ? | 53 Yes | 16 No |
Post New Answer View All Answers
Explain about relational operator join?
explain detail about ftp in datastage?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
Who are naive users?
What is dbms explain in brief?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
What are data modelling techniques?
Write the fastest query to find out how many rows exist in a table?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What is a database development?
Explain about the storage and physical database design?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
What is the database development process?
Explain about post-relational databases?
