I'm just curious. Is there an optimal ratio for index to data in MySQl table?
Data 981,724 Bytes Index 246,784 Bytes
grandpa
3:41 am on May 23, 2004 (gmt 0)
Wrong forum?
mcavic
4:37 am on May 23, 2004 (gmt 0)
I think it really depends on the select statements that you're using. I have a table where the index is actually larger than the data (due to full-text search), and it still runs okay. And some where an index isn't even needed.
In general, I'd say that 1:4 index to data is fine, if that's what it takes to get the job done.
