Re: Hints in Practice

On 23.08.2006 00:09, Jonathan Lewis wrote:
> Fairly close - especially on OLTP systems where
> the queries tend to be relatively simple and fairly
> precisely targeted - and most especially when
> you have a good schema design, use proper
> data types and include all the constraints.
>
> On datawarehouse/batch/dss you may need to
> fall back to hints rather more often because
> large queries with many joins and predicates
> can run into problems with difficult cardinality
> estimates, and do silly things.
>
> But if you need to use hints in a (complex) query,
> you need to be very thorough and ensure that you
> use plenty of hints if you want to guarantee a specific
> execution path.

Thank you for this detailed answer. Thanks also to Frank and Daniel.

Kind regards

        robert Received on Wed Aug 23 2006 - 06:36:55 CDT