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 |
How to set up sql*plus output format in oracle?
What is sql catalog?
What is delimiter in pl sql?
i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???
3 Answers Scope International,
What is the clause we need to add in function body to return variable?
what are all the different normalizations? : Sql dba
What is a record in pl/sql?
how are rank and dense rank being alloted for column with same values over a particular column
How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)
How do you optimize SQL queries ?
6 Answers CarrizalSoft Technologies, Infosys, Oracle,
What is sql analyzer?
how to convert character strings to dates? : Sql dba