I'm guessing that when you looked at the explain plan and found the index not being used you realized the analyzer was confused. You probably could have provided a hint to use the index.