statspack report

[mike2000]

Jeff,

thanks for all of your response.

talking FTS, I just found out that it's true the problem is FTS and what I don't understand is all of the neccessary indexes are there and they are not being used. the client anlyzed objects on this database every night and I don't think it's a good thing to do. So what I did was to add a hint into one query and it's used indexes.

The main question is why Oracle sometimes picked up the indexes and sometimes it's not???
rebuilt indexes is going to help ????


could you please tell me why and how to fix this problems???

thanks