Method, apparatus, server, and storage medium for executing structured query language
The embodiment of the invention relates to the field of database, and discloses an execution method, a device, a server and a storage medium of a structured query language. In the invention, the method comprises the following steps of: querying data from a heat data table according to an SQL stateme...
Gespeichert in:
Hauptverfasser: | , |
---|---|
Format: | Patent |
Sprache: | chi ; eng |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Zusammenfassung: | The embodiment of the invention relates to the field of database, and discloses an execution method, a device, a server and a storage medium of a structured query language. In the invention, the method comprises the following steps of: querying data from a heat data table according to an SQL statement; wherein, the heat data in the whole table is stored in the heat data table; Based on the data queried from the hot data table, the execution result of the SQL statement is determined. The implementation mode reduces the amount of data to be queried by the executing device of the SQL statement, and improves the execution efficiency of the SQL statement.
本发明实施例涉及数据库领域,公开了种结构化查询语言的执行方法、装置、服务器和存储介质。本发明中,该方法包括:根据SQL语句,从热数据表中查询数据;其中,热数据表中存储有全表中的热数据;根据从热数据表中查询的数据,确定SQL语句的执行结果。该实现方式减少了SQL语句的执行装置需要查询的数据量,提高了SQL语句的执行效率。 |
---|