'Why I can index text field use Btree?
When I read the document https://mariadb.com/kb/en/text/#indexing
I see that: "TEXT columns can only be indexed over a specified length;..; Internally, this uses hash indexing to quickly check the values and if a hash collision is found, the actual stored values are compared in order to retain the uniqueness.".
But when I trying to create an index by query:
CREATE INDEX content_text_IDX USING BTREE ON content (field_text);
I still can create btree index without specifying any length.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
