This is a discussion on Question About "Index Length" within the MySQL Database forums, part of the Database Forums category; hey there I was just perusing a database with the MySQL Administrator tool, and I noticed that some of my ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
hey there
I was just perusing a database with the MySQL Administrator tool, and I noticed that some of my tables have larger Index Length's than Data Length's... for example: 80kB index vs 15kB data (76 rows so far) 73kB index vs 42kB data (2827 rows so far 7.1MB index vs 6.5MB data (77,241 rows so far) Generally, I've created indexes on all columns that could be JOINed/WHEREd in a query... Is this a problem? Are there negative implications for this (aside from taking up space on the server)? Thanks. |