Community

A Workaround for MySQL ERROR 1070

(Ike Walker) As documented in the Reference Manual MySQL supports a maximum of 16 columns per index. That’s more than sufficient for most index use cases, but what about unique constraints? If I create a fact table with more than 16 dimension columns in my star schema, and then try to add an index t

Read More - Register for Free Membership