maintenance on DB??

What should be done on the DB over time to insure the system operates efficiently?

Is there a way to archive/compress or delete attachments in the DB as a recurring task??