very interesting. I guess these complex data skew issues is pretty hard to workaround and can throw off any query optimizer. Please change the spelling for vulnerability in article caption.
The main point here - the problem is not in data skew at all. It is just a bug, because optimiser should use statistics on the column it really uses for sorting. So, IMO, it is a design issue.
very interesting. I guess these complex data skew issues is pretty hard to workaround and can throw off any query optimizer. Please change the spelling for vulnerability in article caption.
Thanks, changed.
The main point here - the problem is not in data skew at all. It is just a bug, because optimiser should use statistics on the column it really uses for sorting. So, IMO, it is a design issue.