![]() Must specify a prefix length for the index. When you index a BLOB or TEXT column, you Indexing only a prefix of column values in this way can make you can create an index that uses only the first N characters of theĬolumn. Looking at MySQL documentation for Column Indexes we find: ![]() Note that the article doesn't tell you how to create such a "prefix" index. Theīeauty of this approach is that you can apply it to existingĪpplications without any need to modify the column to BINARY orĪnything else-it’s an indexing-only change and doesn’t require the If it’s a secondary index, this is generally good enough. I usually find that the first 8 to 10 characters are In many but not all cases, you don’t need to index the full length of
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |