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

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1066


What is a bit datatype?

987


What is an indexed view?

956


Differentiate between SQL and ORACLE joins and write their syntax.

1033


Explain how to maintain a fill factor in existing indexes?

995


What is the need for group functions in sql?

1081


What is nonclustered index on computed columns?

955


How to execute multiple stored procedures at one time in sql server?

1011


what is the difference between openrowset and openquery?

1087


Is sql server a database?

992


What is report server project?

147


What is analysis service repository?

1023


When cursors are useful?

1100


What is stretch database in sql server?

1064


What are the acid properties?

1003