When would you denormalize?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / geethu

8 Answers
17330 Views
MBT, Microsoft, MMU, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

When would you denormalize?..

Answer / dai

AFTER INDEXING ALSO WHEN THE TABLE ACCESS
WILL BE SLOW ie. THE PERFORMANCES is low
we need to denormalize

Is This Answer Correct ?

10 Yes

1 No

When would you denormalize?..

Answer / r.s.chauhan

When query is fetching Data from different-2 and small
fragmented tables then we have to De-normalize.

Is This Answer Correct ?

3 Yes

1 No

When would you denormalize?..

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

When would you denormalize?..

Answer / haseeb

when the data is so scattered in the form of tables and we
cannot find appropriate data easily from the database,then
we need denormalization.

Is This Answer Correct ?

2 Yes

1 No

When would you denormalize?..

Answer / prasi

de-normalize is used, when their,, is main benefit of
denormalization is improved performance with simplified
data retrieval and manipulation. This is done by reduction
in the number of joins needed for data processing.

Is This Answer Correct ?

1 Yes

0 No

When would you denormalize?..

Answer / lalit kumar verma

Basically De-normalisation is used in data ware house where
no need to do any manipulation work ....

Is This Answer Correct ?

2 Yes

3 No

When would you denormalize?..

Answer / nagendra

the output of joins is denormalise

Is This Answer Correct ?

1 Yes

3 No

When would you denormalize?..

Answer / sandipan sinha

if I am in need to see the data set in a tabular format
where for each column entry in primary key we can have more
than one entries in other columns,ssometimes they are
needed to be added and summed up together.

Is This Answer Correct ?

0 Yes

2 No

Post New Answer