SQL Server Performance

View and Stored Procedure

Discussion in 'General Developer Questions' started by vimalpercy, Oct 27, 2006.

  1. vimalpercy New Member

    Hello
    I can use either a VIEW or a SP to get results from 2 or more tables that were joined.

    View act more like a table where you have all the logics combined and when called from your application it is more like calling from a TABLE.
    But Stored procedure-- I copied the same thing which i have it in view and called from the application and it worked the same.

    I just want to know if there is any performance enhancement issues using either VIEW or SP.

    Which one is ideal for good performance?

    Thanks and regards
  2. ranjitjain New Member

    Hi,
    Please read about views and SPS in BOL for more detail.
  3. vimalpercy New Member

    Hello Thanks Ranitjain.
    I never heard about BOL. Can you give some description?

    thanks and regards
  4. ranjitjain New Member

    BOL is sql server BOOKS ONLINE HELP file
  5. vimalpercy New Member

Share This Page