Re: Is it considered good practice to use stored procedures for most tasks?

Laurenz Albe schrieb am 18.04.2019 um 10:36:
>> For sure do not allow your application to touch directly tables, use views and sp,
>> lately I'm abandoning views for table functions.
> 
> As far as I know, a table function result is materialized on the server,
> and you have to wait for the query to finish before you can retrieve the
> first row.

Is that true for SQL functions as well? 

Especially when they are inlined, I can't imagine they are handled differently than a regular query. 

Thomas