Suppose I have a table with fields | a | b | c | d | ... | z | which contains millions of records and which will serve millions of queries a day. And the field
z holds the
id of some parameter which can be one of the five possible values. This parameter will never get new values.
What I need is the maximum possible speed and performance of
select from this table. All other query types performance does not matter. Disk space doesn't matter much too.
Very important point is that in each
select query I will always specify the value of
z to only one value ( e. g.
where z = 1 ) Also ib the
select query I will always filter record by other fields and also I will make some joins.
The question is: will it boost the performance of
select to split the table into five tables each corresponding to one of the five possible values of
z? I am going to use MySQL database but I would like to hear the general answer if one exists.