improve cardinality estimation
From: Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
Date: Tue, 27 Oct 2020 17:31:09 +0200
Message-ID: <CA+riqSX+Dd0tcAWn598mZC5uLwBjgCpjs0ha4-sL9pvn5YNGwA_at_mail.gmail.com>
Hello,
Date: Tue, 27 Oct 2020 17:31:09 +0200
Message-ID: <CA+riqSX+Dd0tcAWn598mZC5uLwBjgCpjs0ha4-sL9pvn5YNGwA_at_mail.gmail.com>
Hello,
I found a query with a very bad execution plan due to low
cardinality evaluation of below where clause
where
Is there any way I can improve the estimate (like extended stats, etc) ?
Thanks for your help.
sysdate between trunc(col_from_date) and trunc(nvl(col_to_date,sysdate+1))
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 27 2020 - 16:31:09 CET