SQL server : XML : Data Base Table Optimization

Question

I have a SQL server DB , which have a Table , which Log every Exceptions with details along with 2 XML's (1 for Request , 1 for Response).

These 2 XML's are Compressed.

Now as the Data volume is high , I need to clean the Table in every 3-4 month.

What are the Optimization technique , I can use to avoid Data Clean up's.

Answer 1

1. Create Indexes on all columns that require searching.
2. Run optimize table tablename (or similar according to your RDBMS) through cron job every day.