… I work out the tradeoff between the more versatile single column indexes versus having multiple multi-column indexes that are tailored for each query type? At what point do I need to say, there are too many indexes…
Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!
March 4, 2013 By 7 Comments
… an *InnoDB* table with a single VARCHAR column named “value”. OK, sounds easy …_CLUST_INDEX causing me issues, I tried adding a second column to …then we might expect to get back multiple matches containing the words “James” and … “Alphonso Lee Peterson Sr” record versus the “James R Peterson” one, …
