Splash Image

TiDB SQL Tuning Lab 2: Partitioned Tables

TiDB Self-Managed
60 Mins
TiDB SQL Tuning
Architect, Developer, DevOps
Log in to view the details

Lab Description

In this hands-on lab, you will create and manage Range partitioning, Range COLUMNS partitioning, List partitioning and List COLUMNS partitioning tables. You will learn about the differences between Hash partitioning and Key partitioning tables. Finally, you will compare the performance between partitioned and non-partitioned table.

Featured Labs for DeveloperMore

Splash Image
Getting Started with TiDB Cloud Serverless
TiDB Cloud Serverless|90 Mins
Learn more
Splash Image
Working with TiDB Using mysql-connector-python
TiDB Cloud Serverless|90 Mins
Learn more
Splash Image
Build RAG and Text2SQL AI Applications with Amazon Bedrock
TiDB Cloud Serverless|90 Mins
Learn more
Splash Image
Build RAG and Text2SQL AI Applications with OpenAI
TiDB Cloud Serverless|90 Mins
Learn more

Featured Labs for DBAMore

Splash Image
Database Zero Downtime Under Availability Zone Failure
TiDB Self-Managed|60 Mins
Learn more
Splash Image
Database Scaling In and Scaling Out
TiDB Self-Managed|45 Mins
Learn more
Splash Image
Migrate from MySQL to TiDB Using TiDB Data Migration
TiDB Self-Managed|90 Mins
Learn more
Splash Image
New Features in TiDB 8.1 and 8.5
TiDB Self-Managed|90 Mins
Learn more

Featured Labs for ArchitectMore

Splash Image
Database Zero Downtime Online Upgrade With TiProxy
TiDB Self-Managed|60 Mins
Learn more
Splash Image
Using Resource Control with Mixed Workloads
TiDB Self-Managed|90 Mins
Learn more
Splash Image
Migrate from MySQL to TiDB Using TiDB Data Migration
TiDB Self-Managed|90 Mins
Learn more
Splash Image
Using TiDB as an Operational Data Layer
TiDB Self-Managed|90 Mins
Learn more