Pushpith
Something to consider is that disabling a category entry for requests only prevents new cases from selecting the given category. Any existing cases that name the given category would continue to be accessible.
Can you describe what you are trying to do here? Did you want the given tickets that name an inactive category to disallow case updates? If so, what should happen to those cases when you disable a category?
I do not think that data partitioning will be able to help as it would be too much overhead to take into account the category's active state. Maybe consider including an activity to mass close all cases that name the given category when you are moving to disable the category?