I keep having timeout issues on one of my Visual Basic programs that is talking to an SQL db. I ran into a tool a long time ago that can help your queries to be more efficient. I think it analyzed the incoming queries and built indexes to make them more efficient. It was in SQL, not a 3rd party tool.
Does that ring a bell with anyone?