Оптимизация БД для ускорения выполнения запросов - MySQL

id INT(11)
prefix CHAR(2) 
num_ber VARCHAR(20) 
full_name VARCHAR(180) 
name_1 VARCHAR(100) 
name_2 VARCHAR(100) 
name_3 VARCHAR(100) 
vol_1 FLOAT 
vol_2 FLOAT 
accuracy INT(1) 
post_name VARCHAR(100)

SELECT DISTINCT post_name FROM name_db WHERE post_name IS NOT NULL ORDER BY post_name

SELECT DISTINCT name_1 FROM name_db WHERE post_name = '$post_name' AND name_1 IS NOT NULL ORDER BY name_1

SELECT COUNT(num_ber) FROM name_db WHERE name_1 = '$name_1' AND num_ber IS NOT NULL