Splash Image

TiDB SQL Tuning Lab 4: Optimizing Queries

TiDB Self-Managed

60 Mins

Application Migration SQL Tuning

Architect Developer DevOps

7 credits to start the lab

Log in to view the details

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

Splash Image

Use TiDB as a Unified Storage for AI Apps (Amazon Bedrock)

TiDB Cloud Starter|

TiDB XGenerative AI

Splash Image

Build RAG and Text2SQL AI Apps (Amazon Bedrock)

TiDB Cloud Starter|

TiDB XGenerative AI

Splash Image

Working with TiDB Cloud Using mysql-connector-python

TiDB Cloud Starter|

Splash Image

Working with TiDB Cloud Using JDBC

TiDB Cloud Starter|

Featured Labs for ArchitectMore

Splash Image

Database Zero Downtime Under Availability Zone Failure

TiDB Self-Managed|

Foundational CapabilityDisaster Recovery

Splash Image

Database Seamless Scalability

TiDB Self-Managed|

Foundational CapabilityScalability

Splash Image

Using TiDB as an Operational Data Layer

TiDB Self-Managed|

Foundational CapabilityHTAP

Splash Image

Practical Database Features For SaaS Applications

TiDB Self-Managed|

Foundational CapabilitySaaS

Featured Labs for DBAMore

Splash Image

Database Zero Downtime Online Upgrade With TiProxy

TiDB Self-Managed|

Foundational CapabilityHigh Availability

Splash Image

TiDB Admin Lab 5: Using Resource Control with Mixed Workloads

TiDB Self-Managed|

Resource ControlMulti-Tenant

Splash Image

Migrate from MySQL to TiDB Using TiDB Data Migration

TiDB Self-Managed|

Foundational CapabilityData Migration

Splash Image

New Features in TiDB 8.1 and 8.5

TiDB Self-Managed|

Foundational Capability8.x New Features