Re: Oracle 8i and poor query performance in some queries

> Now the problem seems to be an optimizer problem.

Which is precisely why you'll want to set up Statspack to see which SQL statements you are having difficulties with. Then make sure that the CBO is running these statements properly.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"