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
    vimalpercy, Oct 27, 2006
    #2

  2. ranjitjain New Member

    Hi,
    Please read about views and SPS in BOL for more detail.
    ranjitjain, Oct 27, 2006
    #2

  3. vimalpercy New Member

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

    thanks and regards
    vimalpercy, Oct 27, 2006
    #2

  4. ranjitjain New Member

    BOL is sql server BOOKS ONLINE HELP file
    ranjitjain, Oct 27, 2006
    #2

  5. vimalpercy New Member

    vimalpercy, Oct 27, 2006
    #2

Share This Page