When would you denormalize?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
What are sql ddl commands?
What version is sql?
How delete a row in sql?
What do you mean by stored procedures? How do we use it?
what are the 'mysql' command line options? : Sql dba
write a qurey for finding the length of the sting.
Is truncate ddl or dml?
Which is better join or inner query?
How to run sql functions in pl/sql?
What is form and report?
write a query to display diference between two dates in sql server
What is sql procedures and functions?