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...

When would you denormalize?

Answer Posted / priya

Denormalization is the process of putting one fact in
numerous places (its vice-versa of normalization).Only one
valid reason exists for denormalizing a relational design -
to enhance performance.The sacrifice to performance is that
you increase redundancy in database.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does view store data in sql?

947


Difference between truncate, delete and drop commands?

1065


How do you explain an index number?

1080


what is transaction? : Sql dba

992


Why do we need view in sql?

969


how to present a past time in hours, minutes and seconds? : Sql dba

991


Lookups are a key component in sql server integration services (ssis). Explain its purpose?

984


Explain the uses of a database trigger?

1016


What can you do with pl sql?

1079


What pl/sql package consists of?

1060


What is the example of procedure?

911


What is a native sql query?

1041


What is difference between pl and sql?

1035


How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2209


Can ddl statements be used in pl/sql?

1122