To speed up queries you can:
Note If you use the Performance Analyzer, it will suggest where to create indexes and relationships.