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.