[thelist] Very Large MySQL Table

Jason Handby jason.handby at corestar.co.uk
Tue Feb 10 08:08:58 CST 2009


> > You could add 26 SMALLINT columns to your table,
> > each with its own index.
> 
> jason, good idea, i like the creativity
> 
> sadly, mysql can use only one index for each table in a query

Hmmm that sucks... Ah well. Anyone else have any ideas? I'm intrigued.


J




More information about the thelist mailing list