'Using Select query with more than 20 table joins or view with the same query in frequent REST GET by ID API

I have a REST GET API to get a record from database table which had around join with 25 tables and have to fetch few Columns from each of 25 tables.

So querying by

SELECT tableA.id, tableB.name, tableC.data, tabled.eid....table20.aid FROM tableA 
LEFT JOIN tableB on .... 
LEFT JOIN tableC on....
25 join statements 
WHERE a.id = runtime Parameter

Or by

Creating a database view with the same query but with a stored procedure to pass runtime Parameter to view in SQL server.

Which type of querying is better at performance as this API calls are more.?

c++sharpsql-serverentity-frameworkrestasp.net-web-api


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions