My collegue, Kevin Holman, has a blog post with great discussion about SQL maintenance for OpsMgr databases.  Take a look.

 http://blogs.technet.com/kevinholman/archive/2008/04/12/what-sql-maintenance-should-i-perform-on-my-opsmgr-databases.aspx

 Steve