• No they are not duplicates as the key order is different.

    Key order is important as its the way the optimizer searches the index

    So IndexA (Col1,Col2), IndexB (Col2,Col1) are not considered duplicated

    But IndexA (Col1, Col2), IndexB (Col1, Col2, Col3) then IndexA would be considered the duplicate