advantage of views
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: advantage of views

  1. #1
    Join Date
    Oct 2001
    Location
    CANADA
    Posts
    9

    Angry

    I need to get some information on performance benefits of using views Vs tables.
    I have been researching on the internet for some good articles that I could present to
    my client. So far with no luck.

    Thank you in advance!

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Which Search engine did you use ?

    http://www.google.co.uk/search?q=cac...racle+8i&hl=en

    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  3. #3
    Join Date
    Oct 2001
    Location
    CANADA
    Posts
    9

    Thumbs up

    Thank you so much. I use google search engine! I guess I missed this link. Again that you so very much!

  4. #4
    Join Date
    May 2002
    Posts
    2
    I'm not sure you can characterize a view as having performance benefits. The best benefits derived from views are security, convienence and consistency. Views hide query complexities, provide additional security layers and insulate from changes to underlying tables. A view is only a logical representation of the data and therefore performance is still dependent on the underlaying table/index structure and the quality of the sql that creates the view.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width