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

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

1063


What is the maximum length of an extended property?

1034


What is database design and development?

1063


Explain about a primary key?

1039


Who are end users in dbms?

1033


Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

2103


The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

1047


Explain about xml databases?

1113


What are the main phases of database development?

1027


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

1170


How you can make a parameterized view?

1069


What are the constraints on severity level in raiseerror?

1046


Where is dbms used?

1126


What are the three types of database design?

1080


Explain about the storage and physical database design?

968