In this episode, Ahmad Ghazal (Distinguished Engineer at PingCAP) returns to Data in the Hallway and to discuss #database indices, why they're important, and how TiAdvisor automates #index discovery to enhance user workload performance.

• TiAdvisor blog post: https://www.pingcap.com/blog/introducing-tiadvisor-automated-tidb-index-discovery/
• TiAdvisor on GitHub: https://github.com/pingcap/index_advisor

[00:00] Introductions
[01:40] What are database indices and why are they imporant?
[05:47] How are database indices usually created and what are some of the challenges?
[12:18] What are the goals of TiAdvisor and how does it work?
[18:08] What's the output of TiAdvisor?
[21:40] Where can people find examples of TiAdvisor in action?
[23:00] What's the best way for community members to reach out with questions or feedback?
[24:20] What are winters like in Southern California?

If you have any feedback or suggestions for episodes, you can email us at podcast@pingcap.com.

————————— About PingCAP and TiDB —————————

PingCAP is the creator of #TiDB, an advanced, #OpenSource, #DistributedSQL database with #MySQL compatibility. TiDB powers modern applications with a streamlined tech stack, elastic scaling, real-time analytics, and continuous access to data—all in a single database.

————————— Developer resources —————————

💫TiDB Twitter: https://twitter.com/TiDB_Developer
💫Introducing TiDB: https://youtu.be/_QBrPBwFoWM
💫Quick start with TiDB: https://docs.pingcap.com/tidb/stable/quick-start-with-tidb
💫TiDB in #Kubernetes: https://docs.pingcap.com/tidb-in-kubernetes/stable

————————— Connect with PingCAP —————————

🔹Twitter: https://twitter.com/PingCAP
🔹LinkedIn: https://linkedin.com/company/pingcap
🔹Facebook: https://facebook.com/pingcap2015
🔹Slack: https://slack.tidb.io/invite?team=tidb-community&channel=everyone&ref=pingcap
🔹GitHub: https://github.com/pingcap