Try re-writing the query. What is the optimizer mode? Are the tables involved analyzed?
Thanx Sam Life is a journey, not a destination!
Forum Rules