On Wed, 27 Nov 2024 at 15:51, wenhui qiu <[email protected]> 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 provide a
> 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
