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 de-normalization and when do you do it?

Answer Posted / swapna

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 ?    7 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is built-in/administrator?

1005


Explain a checkpoint?

1033


how to trace the traffic hitting a sql server? : Sql server database administration

1879


What is the current pricing model of SQL Azure?

104


Can we update data in a view?

1032


role of sql sever 2005 in database rather than any other database

1940


What is primary key, unique key, and foreign key?

976


Why does sql studio use a single registered database repository? : sql server management studio

999


What are the types of database recovery models?

1125


how can a database be repaired? : Sql server administration

971


What is named calculation? : sql server analysis services, ssas

982


How to find the source of a table in sql server?

997


Explain different types of lock modes in sql server 2000?

931


Explain how many types of relationship?

1029


Define primary key?

1138