Here are the columns of concern for a table describing tasks:
The only requirement for
Task_ID is that it is unique per every
Org_ID, however I would prefer not handle that programatically and that it be auto incremented.
The requirement for the
Org_ID is that I would like to run metrics and analytics using sort operations with the table organised by
Org_ID and ported nationally some of the task properties. The table being clustered on
Task_ID would be useless, but would be very beneficial to generate on
From reviewing the documentation, it seems that clustering is picked for you in MariaDB where it will use the primary key, a unique non-nullable index, or a background auto generated index in that order.
I am pretty new to MariaDB and was hoping for some help in picking the right solution. From what I understand I can't find a good way to auto increment and cluster how I want it to as well.