Re: Ignore histograms on sql level
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 19 Jan 2021 13:53:09 -0500
Message-ID: <a19f9289-f1c2-a59f-a610-fb583ec26341_at_gmail.com>
Date: Tue, 19 Jan 2021 13:53:09 -0500
Message-ID: <a19f9289-f1c2-a59f-a610-fb583ec26341_at_gmail.com>
I like the opt_param solution the best because it only affects a single query and will not cause trouble elsewhere.
On 1/19/21 1:20 AM, Tanel Poder wrote:
>
> SELECT /*+ FULL(c)
> * opt_param('_optimizer_use_histograms','false')* */
> COUNT(*)
> FROM sh.customers c
> WHERE cust_year_of_birth = 1913;
-- Mladen Gogala Database Consultant http://mgogala.byethost5.com -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 19 2021 - 19:53:09 CET