Wrong column stats in 10053
From: Dominic Brooks <dombrooks_at_hotmail.com>
Date: Tue, 11 May 2021 10:34:35 +0000
Message-ID: <DB7PR04MB4443CB80407826BB7F234F08A1539_at_DB7PR04MB4443.eurprd04.prod.outlook.com>
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.
Date: Tue, 11 May 2021 10:34:35 +0000
Message-ID: <DB7PR04MB4443CB80407826BB7F234F08A1539_at_DB7PR04MB4443.eurprd04.prod.outlook.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 11 2021 - 12:34:35 CEST