Leaving Time-Consuming and Troublesome SQL Optimization to DAS

1) Challenges

Challenge 1 — How can we select a reliable optimization recommendation algorithm to generate reliable suggestions?

SELECT * 
FROM t1
WHERE time_created >= '2017-11-25'
AND consuming_time > 1000
ORDER BY consuming_time DESC
IX1(time_created)
IX2(time_created, consuming_time)
IX3(consuming_time)
IX4(consuming_time, time_created)

Challenge 2 — How can we ensure sufficient SQL compatibility?

Challenge 3 — How can we build a capability-based test set with sufficient coverage?

a)schema设计:如表、已有索引、约束等;
b)各类统计信息数据;
c)环境参数等等。

Challenge 4 — How can we build diagnosis and optimization capabilities for a large number of SQL statements?

2) Capability Building

2.1 Core Technical Architecture

Figure 1. Core technical architecture of the SQL diagnosis and optimization engine

2.2 Building a Capability-based Test Set

Figure 2. Test case system

3) Practices

4) Conclusion

Original Source:

--

--

--

Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:https://www.alibabacloud.com

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

7 Agile Project Management Tools that you should Know

Magic commands in IPython.

10 Fun Facts About Programming

System and Hardware Information using Python — PyShark

Python Django complete roadmap

Python django complete road map

Insure Dao Testnet

Flutter iOS App Store Release process

Migrating On-Prem VMs to Azure using Azure Migrate (Hyper-V) Part 02

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alibaba Cloud

Alibaba Cloud

Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:https://www.alibabacloud.com

More from Medium

Working with Cosmos DB-Cassandra

Cassandra Database

Apache Kafka

Apache Kafka 101 in a nutshell