The schema that represents the market and derived data in the RAPCache database can significantly affect truncation performance.
Sybase recommends that, while designing the market and derived-data schema, you:
- Have an index on the data age column for the table that stores market and derived data, because this enhances the performance of delete statements.
- Use round-robin partitioning to partition the database table that stores the market and derived-data because the RAP system can delete data concurrently from multiple partitions. This significantly improves truncation performance.
See the Adaptive Server Enterprise Performance and Tuning: Basics guide for additional information on performance-centric database and schema design principles.