Query acceleration

Overview

ApsaraDB for SelectDB uses the MySQL protocol and is compatible with standard SQL syntax. Therefore, you can directly use MySQL-compatible tools such as CLI tools, Java Database Connectivity (JDBC) or Open Database Connectivity (ODBC)driver, and visualization tools to connect to ApsaraDB for SelectDB instances. This way, you can use standard SQL syntax for data analysis.

ApsaraDB for SelectDB provides data analysis services such as a new optimizer based on the Cascades framework, a pipeline-based execution engine, high-concurrency point queries, materialized views, index acceleration, and optimization on join operations. In most cases, ApsaraDB for SelectDB automatically optimizes the planning and execution process for queries. This allows you to directly use the performance analysis service provided by ApsaraDB for SelectDB for data queries. If you have requirements on higher data query performance in specific scenarios, you can analyze data and optimize query performance based on the query acceleration feature of ApsaraDB for SelectDB.