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 is nvarchar max in sql?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
what are the advantages of using stored procedures? : Sql dba
What are the default Oracle triggers??
i have some prob lem to tell me about my self in interview first round ...
State the advatage and disadvantage of Cursor's?
What is the difference between sql/pl-sql/embeded sql?
Types of joins ?
3 Answers Digital GlobalSoft, HeadStrong,
Is sql a microsoft product?
what is difference b/w pravite procedures and public procedures?
3 Answers Steria, Wipro, Zensar,
define different types of trigger. : Sql dba
how to include character strings in sql statements? : Sql dba