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 / sd

Denormalization is introcution of controlled redundancy in
the database.

Use denormalization generally to optimize performace of
select query. to minimize joins used in the query.

Is This Answer Correct ?    53 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I detect whether a given connection is blocked?

975


What is DB Development software?

1996


What are the three basic rules which are to be followed for the relational model of the database?

925


How can you log an error to the server event log from a stored procedure?

1027


On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

945


Which four data types cannot be used as a return type from a user-defined function?

959


How to use online Backups?

2145


Explain about relational operator join?

973


What is normalization? Explain different levels of normalization?

62676


What are data modelling techniques?

895


Explain what a database is?

974


To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

3939


What are the types of database model?

1021


Explain the cube operator?

930


Which data type cannot be used as a parameter in a udf?

902