Thanks for your prompt response.
I’ll speak to my company if we can contact you , but we are a small company so I doubt if I’ll get approval. In any case, we are partitioning at a prototype stage now, so looks like it’ll be me who needs to do it . I’ll definitely contact you in case we need to partner with someone.
If I use the option , can I directly enclose (for example) the following SQL?
CREATE TABLE members ( firstname VARCHAR(25) NOT NULL, lastname VARCHAR(25) NOT NULL, username VARCHAR(16) NOT NULL, email VARCHAR(35), joined DATE NOT NULL ) PARTITION BY KEY(joined) PARTITIONS 6;
Are there any other limitations I should know?