sweetytrivedi

 Profile Answers by sweetytrivedi Questions by sweetytrivedi

• Jun 18th, 2008

Denormalization is the process of attempting to optimize the performance of a DB by adding redundant data or by grouping data. The recommendation is always to use this for teh logical design

hari prasad

• Mar 19th, 2007

When its a large data base and our main constraint is the  cost(time) than we concentrates on fast retriving .so we go for denormalization instade of joing(complex relation calculcus) too many table and be in much complexicity with hign normalization.

Answer Question  Select Best Answer

mudassir

• Mar 26th, 2014

I have created VIEW in oracle with more than one table and i tried to delete the record by using the command "delete viewname where fieldname = 3 and the record is get delete. Can you plz explain why this happed

fayaz ahmad khan

• Sep 23rd, 2013

View is used for simplicity and for security of a table in simply a query can also called a view and a stored query which is used a lot of time then it can waste our time so a view is used to reduce a time confusion

Answer Question  Select Best Answer