what is difference between normalization and
denormalization.
in normalization all tables are normalizad format or not.
what r the types of indexes are there.
what is difference b/w bitmap,b-tree,unique and function
based indexes.
- 2 Answers
- 23413 Views
- KPIT, I also Faced
- E-Mail Answers
Answer Posted / samarth
Denormalization is the process of introducing redundancy
into a table by incorporating data from a related table.
Tables are usually denormalized to prevent expensive SQL
join operations between them.
One should always normalize to third-normal form and only
apply denormalization selectively as a last resort if
performance problems are experienced. Remember that
denormalizations is not free and introduces the following
problem into the design:
More disk space is used as the same data is duplicated in
more than one table
DML operations are more expensive as the same data must be
maintained in more than one table
You run the risk that the data can get "out of sync"
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
New Entrepreneurs agengy was established on
Justify your suitability for the position?
suppose the price elasticly of demand for text books is two and the price of the texr book is increased by 10%.by how much does the quantity demand fall? inter result & discuss resons for the fall in quantity demand?
What is Payroll?
Urgent Required a Content Writer in Our company if there is any one female kindly contact @ hr@silvertouch.com
why do u want to become a manager
ROLES AND RESPONSIBILITIES OF A BUSINESS MIS MANAGER(NON IT)?
The present state of recession in the IT industry as a human resource manger how are you going to undertake human resources planning at macro level to tide over this crisis ?
A. Distinguish between the individual and the group decision - making, explaining the advantages and disadvantages of group decision-making. B. Distinguish between individual change and organizational change.
Management can be thought of as a process, a discipline , a human activity and a carrier ? Do you agree?
How did you go about it?
globlisation of market. merit or demarit
Give a relationship between concept, Hypothesis and Theory. What are the Salient features and classifications?
What are the advantage of internal sources of recruitment?
what do we see as our primary and secondary roles within a company?
