Hi ! Can I create index for for very large field (65535 symbols)? If I have 100,000 rows in table, can it work properly with that index ? Thanks !
No.
Indexes are 'smaller' copies of the real table. Making an index on all 65535 characters would mean that the index is a 1:1 copy of the table, and thus just as big and slow.
