mysql - Simple table partitioning? -


i'm trying learn partitioning - have large mysql database following structure:

name (varchar), id (int), dob (int), height (int) 

around 70% of rows in table not have value dob (this value null), wish separate these rest of table speed queries remaining 30% of table.

example queries:

select name mytable id = ' ' limit 1; insert mytable (height) values (180) id = '1234'; 

this large table, , therefore query take while execute - therefore using partition may make sense speed up.

is there simple partition can create separate these?

i'm aware there different types of partitioning (hash, key, list, column) , i'm bit uncertain how best table?


Comments

Popular posts from this blog

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

asp.net - Problems sending emails from forum -