I would like to set up an index for a
LONGTEXT column using:
CREATE INDEX post_meta ON wp_postmeta (meta_value(8));
There are currently ~1 million rows in the relevant table.
- Will creating this index affect the data in any way whatsover, for example, droping leading 0's or anyhting like that?
- Is there any reason NOT to do this? There are many rows with content greater than 8 characters, but I frequently query on a type of entry that is 8 or less.