Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is denormalization and when would you go for it?

Answer Posted / abarna(cts)

As the name indicates, denormalization is the reverse
process of normalization. It's the controlled introduction
of redundancy in to the database design. It helps improve
the query performance as the number of joins could be
reduced.

Is This Answer Correct ?    34 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In which table collections errors are stored.

2391


What is DB Development software?

2052


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?

950


What is database design and development?

989


Explain about the relational database?

1040


What is an application role and explain a scenario when you would use one?

986


How can you fix a poorly performing query?

1157


Why does this query return 0?

997


How can I detect whether a given connection is blocked?

1028


Explain about network model?

982


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?

938


Explain the role of indexing in databases?

1108


Explain about relational database management systems?

946


If a column is an image value type, how you can compare column values? How can you use this column in join clause?

982


I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2834