I have a normalized Database. And i have like 150 Clients that connect to this database and use it as an application. I am wondering if Schemas would make the queries run any faster. Simply because I ran a query on a stripped down database and it ran fast and i ran it on my live database and it was much slower. Also If i implemented schemas would that allow me to let the clients hit the database directly for reporting reasons?
I just don't know much about schemas and want to know from someone who does if schemas are a good route to go for any reason Thanks