Report question

Question: What are some best practices and "rules of thumb" for creating database indexes?