What is denormalization and when would you go for it?
Answer Posted / gtp
Denormalization is a technique to move from higher to lower
normal forms of database modeling in order to speed up
database access
| Is This Answer Correct ? | 76 Yes | 9 No |
Post New Answer View All Answers
What is dbms explain in brief?
What are the 18 schemas?
Who are naive users?
Explain about the storage and physical database design?
Explain about the database management systems.
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
How to use online Backups?
Explain about post-relational databases?
Explain about a primary key?
What is normalization? Explain different levels of normalization?
What are the types of database model?
I have a few records all are same structures data, I want to store data in multiple targets how
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
Can an extended stored procedure be called from inside a user-defined function?