Hi Kent,
Take a look at the following link about updating statistics.
You should update statistics before and after a compress operation, after you add or remove topology rules, and after you have finished importing, loading, or copying data into an ArcSDE geodatabase.
Here is a link about rebuilding indexes. If you are using SQL Server Enterprise edition, refer to the following KB article on how to rebuild indexes.