Re: SQL tuning nightmare - db file sequential reads

On Tue, 04 Jul 2006 10:38:08 -0700, DA Morgan wrote:

> I am going to morph from instructor to student and await Jonathan Lewis
> who will hopefully respond.

This strategy is sometimes known as "prayer based optimization", or PBO. Occasionally, it works even better then CBO. Speaking of CBO, my only question is why didn't Oracle Corp. provide a manual like Jonathan? After all, the inner works of the CBO shouldn't be the dark secret of the few, it should be documented.
Personally,I am extremely unhappy with the CBO as it did away with the plan stability (yes, I know about the outlines) and requires me to perform an expensive re-testing for every patch release. The whole thing is expensive and time consuming and slows down the acceptance of the new version. If you ever asked yourself why people are so slow to adopt version 10, it is because an expensive and time consuming tests should be scheduled in order to perform migration. There is another database in this world which has something called "externally stored plans" and there is a guy named Serge who occasionally posts on this group. He might be able to provide even more info about that. That would be extremely handy when migrating to another release. Any chance of Oracle implementing that old DB2 trick?

-- 
http://www.mgogala.com