I don't have access to the partitioning feature, but consider a support ticket system with tens of thousands of tickets being opened everyday and taking about a week to a couple of months in getting resolved. Obviously, if I tried to keep them all in one table ever since the beginning, the table would become HUGE.
My questions are:
- Once a ticket gets resolved, should I move it out of the original table; or
- Should I just move resolved tickets out of the original table after they are 90 months old; or
- Should I move everything whether resolved or unresolved into another table after 90 months and do some kind of
UNIONevery time unresolved queries are sought?