Know where the bottlenecks are........
Do some analysis of your application before diving in head first and say “I can fix this.” Do you really need to modify your sql indexes when the problem is that you are starting up over 300 COM+ objects for one request?
Another note, SQL Indexes are not the answer to everything and every performance problem. Just putting in more indexes will cause performance problems, and possibily some stability problems on the database server (yes I have seen a database crash due to bad sql indexing). 11 random indexes can be much worse than 4 well done indexes. Analyze your app. Know what you need to do and do it.