Re: Optimizer taking too long to determine query path

That's a possibility.... That could open up a whole other can of worms though (mostly political worms).... I think I'll exhaust my other options first. However... If I was to do that, I think that since ONCONFIG is tuned for data access, there wouldn't be much to change... I have another database (star-schema) with 200 million rows joined with 40 million rows joined with 3 other smaller tables with response time <5 seconds. I think I need to look at the database first. Thanks for the suggestion though!!!! I'll definitely keep it in mind. -- Posted via Talkway - http://www.talkway.com Surf Usenet at home, on the road, and by email -- always at Talkway.