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:

Download PDFRequest docs changesAsk questions on TiDB Forum
Playground
New
One-stop & interactive experience of TiDB's capabilities WITHOUT registration.
Was this page helpful?
Products
TiDB Cloud
TiDB
Pricing
Get Demo
© 2023 PingCAP. All Rights Reserved.