Possibly related to a virtual column, all column stats in the 10053 before the
virtual column are correct, then there seems to be a shift/misplacement after
the VC.
But only when there is an inline view and a UNION ALL involved!
Still under investigation.
Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10
From: Dominic Brooks<mailto:dombrooks@xxxxxxxxxxx>
Sent: 11 May 2021 11:34
To: ORACLE-L<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: Wrong column stats in 10053
Has anyone observed wrong column stats (avg len, ndv, nulls, density, min, max)
being used in 10053 trace?
This is in 19.6
For example, 10053 reports stats for column #8 BUSINESS DATE which are actually
the stats for column #9, some ID.
Still under investigation. Just asking early.
Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10