store procedures or materialized view and why?

Question

I encounter with the question "join performs on 3 table and each table has many rows and queries, it returns many responses". live data not required and 2 hours refresh allowed?? which option we use and why?? options:--store procedures or materialized view

Mike Schmitt · Answer

Usually the best solution is to just use a standard View, and query the data live from there. This only stops performing well when we're dealing with exceptionally large data sets (hundreds of thousands of rows perhaps) and/or incredibly complex / resource-intensive JOIN operations. 
 Can you tell us a bit more about your use case and why a standard View wouldn't be sufficient for you?

store procedures or materialized view and why?

Top Replies