>> It has the indexes

Having indexes on a table means nothing if the optimizer does not find the indexes useful.

-Mike

>Thanks, I'll try. It has the indexes, it just happens that when "something" happens the performance goes to crap, otherwise the performance is fine.