TiDB SQL Tuning Lab 6: Optimizer Hints and SQL Plan Management (SPM)

TiDB Self-Managed

60 Mins

Application Migration SQL Tuning

Architect Developer DevOps

7 credits to start the lab

Lab Description

In this hands-on lab, you use SQL hints and SQL Plan Management (SPM) to selection a specific execution plan.

Featured Labs for DeveloperMore

Intermediate

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

Build RAG and Text2SQL AI Apps (Amazon Bedrock)

Working with TiDB Cloud Using mysql-connector-python

Working with TiDB Cloud Using JDBC

Featured Labs for ArchitectMore

Beginner

Database Zero Downtime Under Availability Zone Failure

TiDB Self-Managed|

60 Mins

Foundational CapabilityDisaster Recovery

Learn more

Intermediate

Database Seamless Scalability

TiDB Self-Managed|

90 Mins

Foundational CapabilityScalability

Learn more

Intermediate

Using TiDB as an Operational Data Layer

TiDB Self-Managed|

60 Mins

Foundational CapabilityHTAP

Learn more

Intermediate

Practical Database Features For SaaS Applications

TiDB Self-Managed|

100 Mins

Foundational CapabilitySaaS

Learn more

Featured Labs for DBAMore

Beginner

Database Zero Downtime Online Upgrade With TiProxy

TiDB Self-Managed|

60 Mins

Foundational CapabilityHigh Availability

Learn more

Intermediate

TiDB Admin Lab 5: Using Resource Control with Mixed Workloads

TiDB Self-Managed|

90 Mins

Resource ControlMulti-Tenant

Learn more

Intermediate

Migrate from MySQL to TiDB Using TiDB Data Migration

TiDB Self-Managed|

60 Mins

Foundational CapabilityData Migration

Learn more

Intermediate

New Features in TiDB 8.1 and 8.5

TiDB Self-Managed|

90 Mins

Foundational Capability8.x New Features

Learn more