- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
How to prove that separating schemas increases performance
I have this schema that contains a lot of tables (some 8000 tables which 7700 of them are generated automatically by the apps inner system).
I want to separate the system tables from the user tables by using different schemas, one schema for system, another one for user (storing just user data).
How do I prove that the action I take really increase performance ? What variables / parameters do I have to check ? I need to serve the before-and-after value on to a report.