Re: Consider the number of columns in the sort cost model

On 10/31/24 21:00, Alena Rybakina wrote:
> On 29.10.2024 05:47, Andrei Lepikhov wrote:
> I played around with the examples a bit and couldn't figure out 
> something. When I added the same values ​​to different columns - firstly 
> in a, later in b, the order of the columns for sort operation doesn't 
> change. Isn't this a mistake?
This feature implements a cost-based approach to choosing the grouping 
clauses' order. What kind of 'mistake' do you see here? Is there 
something wrong with the costs, or do you see a bug in the cost 
calculation code? Please specify your request.

-- 
regards, Andrei Lepikhov