give it some good stats - have you done that. There is always the chance that using an index is not the best idea