Why don't you post the SQL statements?
Probably that would help us to determine the use of indexes.