June 19, 2013

Comment: Tools and Techniques for Index Design Webinar Questions Followup

… 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

Comment: How to find wrong indexing with glance view

… seems that we disagree on index merge versus multiple column index. I’m saying that I see index merge working when multiple column indexes don’t. You’re saying… why, but I don’t disagree. One thing is clear: single column indexes are not enough, no doubt about that. Regarding billions of…

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

… 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, …