Ice Breaking Topics

• What was the last book you read, and what did you think of it?
• If you could visit any place in the world for free, where would you go and why?
• When have you realized that slowing down was exactly what you needed?
• Do you think it's important to be on time?
• How do you stay organized and productive?
• How do you stay motivated when working toward long-term goals?
• Imagine designing a theme park inspired by your life. What’s its signature attraction?
• When have you found surprising wisdom in an unexpected situation?

MySql经常用，但是通常就是ORM中间件来CRUD操作，很少关注索引问题，可能是我近些年很少用MySQL做大型的系统了。
现在一面试就遇到所有领域的问题来都来一个问一遍，MySQL的复合索引其实也就一知半解。

面试官的问类似于select语句里where a>100 and b=3 and c=1 能否命中创建的(a, b, c)这种索引，还有a>100能否命中这个复合索引。

我想当然就说，a>100 and b=3 and c=1 只能命令(a, b, c)这种索引， a>100不能命中。唉呀，人家笑了。我说我可能说的不对，我下来试试。好吧查资料，建表，亲自实操一把。