I have a critical performance scenario that,
I have to use more than 100 schema in a database. Each schema having more than 50 tables and few views. I need to use join queries for communicating between tables in these schema.
I would like to know any performance issue there by using this much schema for intercommunicating the tables in one MSSQL database? That means issue in memory, CPU, or any other resources. Thank you.
Best Answer
A schema is just a container (i.e. a place for objects to live) in SQL Server. That said, there should be little to no performance implications with having a large number of schemas. That said, 100 sounds like a large number. Rhetorically, what are you trying to accomplish by having so many?