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

Thread: advantage of views

  1. 05-03-2002, 11:26 AM #1
    bj
    bj is offline Junior Member
    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!
    Reply With Quote Reply With Quote
  2. 05-03-2002, 11:45 AM #2
    Sureshy's Avatar
    Sureshy
    Sureshy is offline Advisor
    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.
    Reply With Quote Reply With Quote
  3. 05-03-2002, 11:49 AM #3
    bj
    bj is offline Junior Member
    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!
    Reply With Quote Reply With Quote
  4. 05-03-2002, 11:51 AM #4
    hensed
    hensed is offline Junior Member
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width