I do not understand this situation. All fields used in the query are indexed. I also have some combo index to satisfy the execution plan. The result returns one record. However, based on the conditions, it can take between one and 40 seconds. What else could be a factor?