On Wed, 27 Nov 2024 at 15:51, wenhui qiu <qiuwenhuifx@gmail.com> wrote:
> HI Japin Li
> Thank you for you reply, Do you think that removing the log2 algorithm because it will be more frequent,I think
sql
> server chose sqrt algorithm after their long-term verification, I think we need to retain sqrt algorithm,The
relevant
> documents are here(
> https://learn.microsoft.com/en-us/sql/relational-databases/statistics/statistics?view=sql-server-ver16),I will
providea
> new patch later with your reply
>
Worth a try.
However, I don't think we need to based on {vac,anl}_scale_factor when using
the sqrt algorithm.
--
Regrads,
Japin Li
