Optimize mysql table ?
- by fabien-barbier
Here is my actual table schema (I'm using Mysql) :
Table experiment :
code(int)
sample_1_id
sample_2_id
... until ... sample_12_id
rna_1_id
rna_2_id
... until ... rna_12_id
experiment_start
How can I optimize both part : sample_n_id and rna_n_id (all are bigint(20) and allow null=true) ?
About values : we can have : ex :
sample_1_id = 2 ,
Sample_2_id = 5 , ...
Note : values can be updated.
Ideas ?
Thanks.