RE: The CBO Lie Detector

From: <oracle-l-bounce_at_freelists.org>
Date: Fri, 9 Jun 2006 20:45:38 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF3F5F20@MSXVS04.trivadis.com>

Charles

>And Oracle is doing... what?

IMHO SQL profiles are a first step in this direction. In fact with them it is possible to store information describing mistakes the CBO does. Their main limitation is that they are bound to a single (or few similar) SQL statement(s). Therefore, to close the loop, they should enhance them to store generic information about the mistakes.

Cheers,
Chris

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 09 2006 - 13:45:38 CDT