Answer / dai

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

Answer / r.s.chauhan

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

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.

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.

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.

Answer / lalit kumar verma

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

Answer / nagendra

the output of joins is denormalise

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.

Which is faster subquery or join?

0 Answers  

what are different types of keys in sql?

0 Answers  

we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?

3 Answers   TCS,

What are sql*plus environment variables?

0 Answers  

What is the basic form of sql query?

0 Answers  

Explain isolation levels. : Transact sql

0 Answers  

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

How do I enable sql encryption?

0 Answers  

What is procedure in pl sql?

0 Answers  

How long it takes to learn pl sql?

0 Answers  

Write a unique difference between a function and a stored procedure.

0 Answers  

Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question

7 Answers   TCS,