These are the sample SQL scripts which has the recommended way to partition the Bill Segment and Adjustment tables and Indexes. Implementations can further customize these scripts and update the partition names, tablespace names and date ranges to make sure they are suited to the implementation.

This appendix consists: