Sign InTry Free

SQL Logical Optimization

This chapter explains some key logic rewrites to help you understand how TiDB generates the final query plan. For example, when you execute the select * from t where t.a in (select t1.a from t1 where t1.b=t.b) query in TiDB, you will find that the IN sub-query t.a in (select t1.a from t1 where t1.b=t.b) does not exist because TiDB has made some rewrites here.

This chapter introduces the following key rewrites:

Was this page helpful?

Download PDFRequest docs changesAsk questions on Discord
Playground
New
One-stop & interactive experience of TiDB's capabilities WITHOUT registration.
Products
TiDB
TiDB Dedicated
TiDB Serverless
Pricing
Get Demo
Get Started
© 2024 PingCAP. All Rights Reserved.
Privacy Policy.