Hi Sarwar, What you’ll find is that for OLTP systems table sizes doesn’t really matter as access patterns should be well structured and serviced by indexes, etc. The only reason to have partitioning in an OLTP system is for table maintenance; like aging out old data for regulatory reasons, etc. Partitioning is most beneficial in OLAP and reporting type systems where queries can make use of partition elimination. When thinking about partitioning I also consider the use of Brin indexes as they can sometime achieve similar or even better results. Also, when considering partitioning especially in a hybrid system one should also think about how it will impact referential integrity. |
