Important

You are viewing the documentation of TiDB v6.0 (DMR). PingCAP does not provide bug fixes for v6.0. Any bugs will be fixed in future releases.

For general purposes, please use the latest stable version of the TiDB database.

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?