Splash Image

TiDB SQL Tuning Lab 1: Clustered and Non-Clustered Indexes

TiDB Self-Managed

60 Mins

Intermediate, Application Migration, SQL Tuning

Architect, Developer, DevOps

Log in to view the details

Lab Description

In this hands-on lab, you will learn how to create clustered and non-clustered indexes. Specifically, we will cover the best practices of using clustered and non-clustered indexes, split the TiKV regions to prevent hotspots, and use the key visualizer.

Featured Labs for DeveloperMore

Splash Image

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

TiDB Cloud Starter|90 Mins

Splash Image

Build RAG and Text2SQL AI Apps (Amazon Bedrock)

TiDB Cloud Starter|90 Mins

Splash Image

Working with TiDB Cloud Using mysql-connector-python

TiDB Cloud Starter|90 Mins

Splash Image

Working with TiDB Cloud Using JDBC

TiDB Cloud Starter|90 Mins

Featured Labs for ArchitectMore

Splash Image

Database Zero Downtime Under Availability Zone Failure

TiDB Self-Managed|60 Mins

Splash Image

Database Seamless Scalability

TiDB Self-Managed|90 Mins

Splash Image

Using TiDB as an Operational Data Layer

TiDB Self-Managed|90 Mins

Splash Image

Practical Database Features For SaaS Applications

TiDB Self-Managed|100 Mins

Featured Labs for DBAMore

Splash Image

Database Zero Downtime Online Upgrade With TiProxy

TiDB Self-Managed|60 Mins

Splash Image

TiDB Admin Lab 5: Using Resource Control with Mixed Workloads

TiDB Self-Managed|90 Mins

Splash Image

Migrate from MySQL to TiDB Using TiDB Data Migration

TiDB Self-Managed|90 Mins

Splash Image

New Features in TiDB 8.1 and 8.5

TiDB Self-Managed|90 Mins