Presto v0.289 Documentation
首页 白天 夜间 BookChat 小程序 小程序 下载 阅读记录
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签

Query Optimizer

来源 Facebook 浏览 1 扫码 打印 2026-10-26 16:03:39
  • Query Optimizer

Query Optimizer

  • Table Statistics
  • Cost in EXPLAIN
  • Cost based optimizations
  • History based optimizations (HBO)
  • Logical Properties of Query Plans
上一篇:
下一篇:
  • 书签
  • 添加书签 移除书签
  • Overview
    • Use Cases
    • Presto Concepts
  • Installation
    • Deploying Presto
    • Command Line Interface
    • JDBC Driver
    • Benchmark Driver
    • Web Connector for Tableau
    • Executing Presto on Spark
    • Deploy Presto From a Docker Image
    • Deploy Presto on a Mac using Homebrew
    • Deploy Presto Using Helm Charts
  • Presto Clients
    • Command Line Interface
    • Presto Console
    • DBeaver
    • Apache Superset
  • Security
    • Coordinator Kerberos Authentication
    • CLI Kerberos Authentication
    • LDAP Authentication
    • Password File Authentication
    • Java Keystores and Truststores
    • Built-in System Access Control
    • Secure Internal Communication
    • Authorization
  • Administration
    • Web Interface
    • Tuning Presto
    • Properties Reference
    • Spill to Disk
    • Exchange Materialization
    • CTE Materialization
    • Resource Groups
    • Session Property Managers
    • Function Namespace Managers
    • Distributed sort
    • Presto Verifier
  • Cache
    • Alluxio SDK Cache
    • Alluxio Cache Service
  • Query Optimizer
    • Table Statistics
    • Cost in EXPLAIN
    • Cost based optimizations
    • History based optimizations (HBO)
    • Logical Properties of Query Plans
  • Connectors
    • Accumulo Connector
    • BigQuery Connector
    • Black Hole Connector
    • Cassandra Connector
    • ClickHouse connector
    • Delta Lake Connector
    • Druid Connector
    • Elasticsearch Connector
    • Google Sheets connector
    • HANA Connector
    • Hive Connector
    • Hive Security Configuration
    • Hudi Connector
    • Iceberg Connector
    • JMX Connector
    • Kafka Connector
    • Kafka Connector Tutorial
    • Kudu Connector
    • Lark Sheets connector
    • Local File Connector
    • Memory Connector
    • MongoDB Connector
    • MySQL Connector
    • Oracle Connector
    • Apache Pinot Connector
    • PostgreSQL Connector
    • Prometheus Connector
    • Redis Connector
    • Redshift Connector
    • ScyllaDB Connector
    • SingleStore Connector
    • SQL Server Connector
    • System Connector
    • Thrift Connector
    • TPCDS Connector
    • TPCH Connector
  • Plugins
    • Redis HBO Provider
  • Functions and Operators
    • Logical Operators
    • Comparison Functions and Operators
    • Conditional Expressions
    • Lambda Expressions
    • Conversion Functions
    • Mathematical Functions and Operators
    • Bitwise Functions
    • Decimal Functions and Operators
    • String Functions and Operators
    • Regular Expression Functions
    • Binary Functions and Operators
    • JSON Functions and Operators
    • Date and Time Functions and Operators
    • Aggregate Functions
    • Noisy Aggregate Functions
    • Window Functions
    • Array Functions and Operators
    • Map Functions and Operators
    • URL Functions
    • IP Functions
    • Geospatial Functions
    • HyperLogLog Functions
    • KHyperLogLog Functions
    • Quantile Digest Functions
    • UUID functions
    • T-Digest Functions
    • Color Functions
    • Session Information
    • Teradata Functions
    • Internationalization Functions
    • Set Digest functions
    • Sketch Functions
    • Pinot Functions
  • SQL Language
    • Data Types
    • Reserved Keywords
  • SQL Statement Syntax
    • ALTER FUNCTION
    • ALTER SCHEMA
    • ALTER TABLE
    • ANALYZE
    • CALL
    • COMMIT
    • CREATE FUNCTION
    • CREATE ROLE
    • CREATE SCHEMA
    • CREATE TABLE
    • CREATE TABLE AS
    • CREATE VIEW
    • DEALLOCATE PREPARE
    • DELETE
    • DESCRIBE
    • DESCRIBE INPUT
    • DESCRIBE OUTPUT
    • DROP FUNCTION
    • DROP ROLE
    • DROP SCHEMA
    • DROP TABLE
    • DROP VIEW
    • EXECUTE
    • EXPLAIN
    • EXPLAIN ANALYZE
    • GRANT
    • GRANT ROLES
    • INSERT
    • PREPARE
    • RESET SESSION
    • REVOKE
    • REVOKE ROLES
    • ROLLBACK
    • SELECT
    • SET ROLE
    • SET SESSION
    • SHOW CATALOGS
    • SHOW COLUMNS
    • SHOW CREATE FUNCTION
    • SHOW CREATE TABLE
    • SHOW CREATE VIEW
    • SHOW FUNCTIONS
    • SHOW GRANTS
    • SHOW ROLE GRANTS
    • SHOW ROLES
    • SHOW SCHEMAS
    • SHOW SESSION
    • SHOW STATS
    • SHOW TABLES
    • START TRANSACTION
    • TRUNCATE
    • UPDATE
    • USE
    • VALUES
  • Migration
    • Migrating From Hive
  • REST API
    • Node Resource
    • Query Resource
    • Stage Resource
    • Statement Resource
    • Task Resource
  • Ecosystem
    • Ecosystem
  • Router
    • Deploying Presto Router
    • Router Schedulers
  • Developer Guide
    • SPI Overview
    • Connectors
    • Example HTTP Connector
    • Supporting DELETE and UPDATE
    • Types
    • Functions
    • System Access Control
    • Password Authenticator
    • Event Listener
    • Presto Client REST API
    • Presto Worker REST API
    • SerializedPage Wire Format
    • Presto Console
  • Presto C++
    • Presto C++ Features
    • Presto C++ Limitations
    • Presto C++ Properties Reference
    • Overview
    • Motivation and Vision
    • Supported Use Cases
  • Release Notes
    • Release-0.289 [2024-08-23]
    • Release-0.288.1 [2024-08-12]
    • Release-0.288 [2024-06-13]
    • Release-0.287 [2024-04-16]
    • Release-0.286 [2024-02-12]
    • Release-0.285.1 [2023-12-30]
    • Release-0.285 [2023-12-08]
    • Release-0.284 [2023-10-11]
    • Release-0.283 [2023-08-08]
    • Release 0.282
    • Release 0.281
    • Release 0.280
    • Release 0.279.2
    • Release 0.279
    • Release 0.278.1
    • Release 0.278
    • Release 0.277
    • Release 0.276.1
    • Release 0.276
    • Release 0.275
    • Release 0.274
    • Release 0.273.3
    • Release 0.273.2
    • Release 0.273
    • Release 0.272
    • Release 0.271
    • Release 0.270
    • Release 0.269
    • Release 0.268
    • Release 0.267
    • Release 0.266
    • Release 0.265
    • Release 0.264.1
    • Release 0.264
    • Release 0.263.1
    • Release 0.263
    • Release 0.262
    • Release 0.261
    • Release 0.260.1
    • Release 0.260
    • Release 0.259.1
    • Release 0.259
    • Release 0.258
    • Release 0.257
    • Release 0.256
    • Release 0.255
    • Release 0.254.1
    • Release 0.254
    • Release 0.253.1
    • Release 0.253
    • Release 0.252
    • Release 0.251.1
    • Release 0.251
    • Release 0.250
    • Release 0.249.2
    • Release 0.249.1
    • Release 0.249
    • Release 0.248.1
    • Release 0.248
    • Release 0.247
    • Release 0.246
    • Release 0.245.1
    • Release 0.245
    • Release 0.244.1
    • Release 0.244
    • Release 0.243.4
    • Release 0.243.3
    • Release 0.243.2
    • Release 0.243.1
    • Release 0.243
    • Release 0.242.1
    • Release 0.242
    • Release 0.241
    • Release 0.240
    • Release 0.239.2
    • Release 0.239.1
    • Release 0.239
    • Release 0.238.3
    • Release 0.238.2
    • Release 0.238
    • Release 0.237
    • Release 0.236
    • Release 0.235.1
    • Release 0.235
    • Release 0.234.3
    • Release 0.234.2
    • Release 0.234.1
    • Release 0.234
    • Release 0.233.1
    • Release 0.233
    • Release 0.232
    • Release 0.231
    • Release 0.230
    • Release 0.229
    • Release 0.228
    • Release 0.227
    • Release 0.226
    • Release 0.225
    • Release 0.224
    • Release 0.223
    • Release 0.222
    • Release 0.221
    • Release 0.220
    • Release 0.219
    • Release 0.218
    • Release 0.217
    • Release 0.216
    • Release 0.215
    • Release 0.214
    • Release 0.213
    • Release 0.212
    • Release 0.211
    • Release 0.210
    • Release 0.209
    • Release 0.208
    • Release 0.207
    • Release 0.206
    • Release 0.205
    • Release 0.204
    • Release 0.203
    • Release 0.202
    • Release 0.201
    • Release 0.200
    • Release 0.199
    • Release 0.198
    • Release 0.197
    • Release 0.196
    • Release 0.195
    • Release 0.194
    • Release 0.193
    • Release 0.192
    • Release 0.191
    • Release 0.190
    • Release 0.189
    • Release 0.188
    • Release 0.187
    • Release 0.186
    • Release 0.185
    • Release 0.184
    • Release 0.183
    • Release 0.182
    • Release 0.181
    • Release 0.180
    • Release 0.179
    • Release 0.178
    • Release 0.177
    • Release 0.176
    • Release 0.175
    • Release 0.174
    • Release 0.173
    • Release 0.172
    • Release 0.171
    • Release 0.170
    • Release 0.169
    • Release 0.168
    • Release 0.167
    • Release 0.166
    • Release 0.165
    • Release 0.164
    • Release 0.163
    • Release 0.162
    • Release 0.161
    • Release 0.160
    • Release 0.159
    • Release 0.158
    • Release 0.157.1
    • Release 0.157
    • Release 0.156
    • Release 0.155
    • Release 0.154
    • Release 0.153
    • Release 0.152.3
    • Release 0.152.2
    • Release 0.152.1
    • Release 0.152
    • Release 0.151
    • Release 0.150
    • Release 0.149
    • Release 0.148
    • Release 0.147
    • Release 0.146
    • Release 0.145
    • Release 0.144.7
    • Release 0.144.6
    • Release 0.144.5
    • Release 0.144.4
    • Release 0.144.3
    • Release 0.144.2
    • Release 0.144.1
    • Release 0.144
    • Release 0.143
    • Release 0.142
    • Release 0.141
    • Release 0.140
    • Release 0.139
    • Release 0.138
    • Release 0.137
    • Release 0.136
    • Release 0.135
    • Release 0.134
    • Release 0.133
    • Release 0.132
    • Release 0.131
    • Release 0.130
    • Release 0.129
    • Release 0.128
    • Release 0.127
    • Release 0.126
    • Release 0.125
    • Release 0.124
    • Release 0.123
    • Release 0.122
    • Release 0.121
    • Release 0.120
    • Release 0.119
    • Release 0.118
    • Release 0.117
    • Release 0.116
    • Release 0.115
    • Release 0.114
    • Release 0.113
    • Release 0.112
    • Release 0.111
    • Release 0.110
    • Release 0.109
    • Release 0.108
    • Release 0.107
    • Release 0.106
    • Release 0.105
    • Release 0.104
    • Release 0.103
    • Release 0.102
    • Release 0.101
    • Release 0.100
    • Release 0.99
    • Release 0.98
    • Release 0.97
    • Release 0.96
    • Release 0.95
    • Release 0.94
    • Release 0.93
    • Release 0.92
    • Release 0.91
    • Release 0.90
    • Release 0.89
    • Release 0.88
    • Release 0.87
    • Release 0.86
    • Release 0.85
    • Release 0.84
    • Release 0.83
    • Release 0.82
    • Release 0.81
    • Release 0.80
    • Release 0.79
    • Release 0.78
    • Release 0.77
    • Release 0.76
    • Release 0.75
    • Release 0.74
    • Release 0.73
    • Release 0.72
    • Release 0.71
    • Release 0.70
    • Release 0.69
    • Release 0.68
    • Release 0.67
    • Release 0.66
    • Release 0.65
    • Release 0.64
    • Release 0.63
    • Release 0.62
    • Release 0.61
    • Release 0.60
    • Release 0.59
    • Release 0.58
    • Release 0.57
    • Release 0.56
    • Release 0.55
    • Release 0.54
暂无相关搜索结果！

    本文档使用 WanXiangYunDang 构建

    展开/收起文章目录

    思维导图备注

    文章二维码

    手机扫一扫，轻松掌上读

    文档下载

    请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
    PDF文档 EPUB文档 MOBI文档

    微信小程序阅读

    BookChat 微信小程序阅读
    微信扫一扫，知识掌上学

    书签列表

      阅读记录

      阅读进度: 0.00% ( 0/0 ) 重置阅读进度