catch.saravana
Member
Hello Everyone,
We have a DB with 900+ tables and approximately 1.1 TB of data. I have couple of quick questions;
1. How do we segregate tables under different areas? I am sure it shouldn't be based on functionality. Can we have it 1 table per area and group of indexes of that table in another area which will lead to 1800 area's?
2. Or do I have to group all the small tables in one area and keep each fast growing tables in separate area?
What is the preferred guidelines for segregating tables and indexes? Do we have any specific article/documentation? Or based on someone's experience please do let me know the best practices.
Regards,
Saravanakumar B
We have a DB with 900+ tables and approximately 1.1 TB of data. I have couple of quick questions;
1. How do we segregate tables under different areas? I am sure it shouldn't be based on functionality. Can we have it 1 table per area and group of indexes of that table in another area which will lead to 1800 area's?
2. Or do I have to group all the small tables in one area and keep each fast growing tables in separate area?
What is the preferred guidelines for segregating tables and indexes? Do we have any specific article/documentation? Or based on someone's experience please do let me know the best practices.
Regards,
Saravanakumar B