englefly commented on issue #64122: URL: https://github.com/apache/doris/issues/64122#issuecomment-4716066411
ndv == 0 && (!isNull(minLit) || !isNull(maxLit)) && nullCount != count 满足上面条件说明数据非常极端,或者是采集有错. 无论那种情况, 这条统计信息的可用性都很低,如果采用就很容易推导出极端的估行,进而产生极端的plan. 这种极端的 plan 大概率会是一个很差的 plan 在列统计信息中, ndv 是最重要,使用最多的量,如果 ndv 不可信,那么这条统计信息被视作无效 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
