Performance Issue

Results 1 to 2 of 2

Thread: Performance Issue

  1. #1
    Join Date
    Dec 1969

    Default Performance Issue

    I&#039;m confused as to when and why I should use a view over a stored proc. I basiclly understand both, but I don&#039;t really know when to use a view over a stored proc. What is the advantage of a view?<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Performance Issue

    a stored procedure returns exactly what you limit to<BR><BR>a view creates all possible records for any situation<BR><BR>table 1 has 1000 records <BR><BR>joins to <BR>Table2 with 10 records<BR><BR>so a view would create (if every record in 1 links to every record in 2) = 10000 records then you limit it (say top 10)<BR><BR>a stored procedure to do the same only returns the top 10!

Posting Permissions

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