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 / sivaraman (gasc)

Denormalization is the process of attempting to optimize
the performance of a database by adding redundant data or
by grouping data. In some cases, denormalization helps
cover up the inefficiencies inherent in relational database
software. A relational normalized database imposes a heavy
access load over physical storage of data even if it is
well tuned for high performance

Is This Answer Correct ?    22 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

963


What is a database development?

964


If a column is an image value type, how you can compare column values? How can you use this column in join clause?

1002


Write the fastest query to find out how many rows exist in a table?

1117


Explain about the database management systems.

970


Explain about the hierarchical model of the database?

1116


Explain about a primary key?

983


In which database can extended stored procedures be added?

904


When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

2215


What is dbms and its application?

1003


Who are end users in dbms?

990


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

977


What are the types of database model?

1094


Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2207


How to customize error conditions.

2150