Indexing a database seems more art than science and proper indexes can have a tremendous speed up for your queries. This really nice talk can help to make better decision and more important can help to make better index design:

  

Tags: ,