TiDB SQL Tuning Lab 4: Optimizing Queries

TiDB Self-Managed

60 Mins

TiDB SQL Tuning

Architect, Developer, DevOps

Lab Description

In this hands-on lab, you determine the optimizer's strategy for a particular query. Add indexes to the tables that the query accesses and evaluate the effect on the query execution plan. Improve the performance of a specific query.

Featured Labs for DeveloperMore

Getting Started with TiDB Cloud Serverless

TiDB Cloud Serverless|90 Mins

Learn more

Building a Graph RAG Application with TiDB

TiDB Cloud Serverless|90 Mins

Learn more

Working With TiDB Using mysql-connector-python

TiDB Cloud Serverless|90 Mins

Learn more

Deploy Your Own Knowledge Base Chatbot with OpenAI

TiDB Cloud Serverless|60 Mins

Learn more

Featured Labs for DBAMore

Database Zero Downtime Under Availability Zone Failure

TiDB Self-Managed|60 Mins

Learn more

Database Scaling In and Scaling Out

TiDB Self-Managed|45 Mins

Learn more

Migrate from MySQL to TiDB Using TiDB Data Migration

TiDB Self-Managed|90 Mins

Learn more

New Features in TiDB 8.1 and 8.5

TiDB Self-Managed|90 Mins

Learn more

Featured Labs for ArchitectMore

Database Zero Downtime Online Upgrade With TiProxy

TiDB Self-Managed|60 Mins

Learn more

Using Resource Control with Mixed Workloads

TiDB Self-Managed|90 Mins

Learn more

Migrate from MySQL to TiDB Using TiDB Data Migration

TiDB Self-Managed|90 Mins

Learn more

Using TiDB as an Operational Data Layer

TiDB Self-Managed|90 Mins

Learn more