Our application has got few tables which has grown to a larger size. Hence one suggestion put forward is to consider table partitioning. Since this does not involve any code changes in the application, we are looking into this option.
1. Is there any disadvantage if we use table partitioning feature
2. Will table partitioning affect the current indexes that exist on the table?
3. Database mirroring is enabled in our schema. Will partitioning have any effect on this?
4. Any suggestion on how we should try this out?
View Complete Post