Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What are the advantages of views?

Oracle
user-image
Question added by ayoub gismsed Ibrahim Salah , مهندس علوم الحاسوب وتقنية معلومات , جامعة بحري
Date Posted: 2016/09/29
Upvote (0) Views (5) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
khalid jabbar Arzooqi
by khalid jabbar Arzooqi , Consultant_ IT Director _ Oracle prof. , private sector

bellow some of  sql views advantages :

  • it could normalize data relations, so end user can get Understandable data.
  • through views you could increase securities, so end user get data as wanted by developer.
  • when designing a view, the definition of  it will be stored on database then developers could not need redefine it, which make their jobs easier.
  • with materialized views, you could decreasing response time. also it might be used on transferring data to other hosts. 

Write Your Answer
More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help