I know, that using indexes in the DB can increase its performance, but since indexes take up a certain amount of physical space of DB, when using unappropriately, they can also cause slowing down DB performance.
I had then a similar thought about stored procedures, but could not find and answer for that. So: Do the stored procedures take some physical space in the database?
If so, can it be so significant that it could slow down a performance of inline sql performed in DB?
In today's world there is no worry about physical space. And there are lots of benefits of using stored procedure. It's not gonna affect performance unless you write some sql queries in stored procedure which has some performance issue. So it's query who will degrade performance rather than the stored procedure.