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

Explain DBCC?

925


How to delete an existing row with delete statements in ms sql server?

1045


What is a view in sql?

943


How to apply cascading referential integrity in place of triggers?

999


If the job running very slow what is the action you do

1849


How to create a simple table to test triggers in ms sql server?

936


What is explicit mode in sql server?

1028


How many triggers you can have on a table?

956


Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

974


What are subquery and its properties?

994


What is subquery explain with example?

1027


How can I check that whether automatic statistic update is enabled or not?

1010


What does ss stand for sexually?

1034


What is efficiency data?

924


Tell me what is difference between clustered and non clustered index?

909