Unfortunately, there is also an unwritten rule about the most selective
column coming first which is followed by most of the application
designers and database administrators. In case of the skip scan, that
rule will cause you to shoot yourself in a foot.
On 8/17/21 4:31 PM, Andy Sayer wrote:
The mechanism is more effective when there are less distinct values of the first column.
Hope that helps,
Andy