We are currently copying data from DB2 to MemSQL and data architect is creating tables in MemSQL according to the requirement. While looking into the table definitions, I noticed the following. on the table.
PRIMARY KEY ( a, b ),
My question is doesn’t the KEY(a) looks redundant here, as PK already has the
same leading column?