Total Pageviews

18 April 2018

What is view? what is advantage and Disadvantage of view?

What is view? what is advantage and Disadvantage of view? 


View just like a virtual table which contains data view simply and query retrieve data dynamically.
in view data show from table in virtual way just like image and data changes when in table data
will be change in view we can not insert, update and delete records dynamically.

Material view is also available in which update records a specific time interval.


Advantage of view

1.View does not store data in physical location.
2.View hide some column from the table.
3.Access restriction since data insert Update and deletion not possible.


Disadvantage of View

1.When table dropped associated view became irrelevant.
2.During view show the data process is very slow.
3. View take large memory.

Contact Form

Name

Email *

Message *