- INDEX `uid_network_received` (`uid`,`network`,`received`),
- INDEX `uid_received` (`uid`,`received`),
- INDEX `uid_network_commented` (`uid`,`network`,`commented`),
- INDEX `uid_title` (`uid`,`title`),
- INDEX `uid_thrparent` (`uid`,`thr-parent`),
- INDEX `uid_parenturi` (`uid`,`parent-uri`),
- INDEX `uid_contactid_id` (`uid`,`contact-id`,`id`),
+ INDEX `uid_network_received` (`uid`,`network`(4),`received`),
+ INDEX `uid_network_commented` (`uid`,`network`(4),`commented`),
+ INDEX `uid_thrparent` (`uid`,`thr-parent`(190)),
+ INDEX `uid_parenturi` (`uid`,`parent-uri`(190)),