We have a procedure which select from a lot of tables. Will there be any performance improvement if we create a view for that select query instead of fetching directly from Table?
Obviously yes, We'd implemented the same when we wanted to share our data to shared services team.