思维导图备注

Presto 0.234 Documentation
首页 白天 夜间 BookChat 小程序 小程序 阅读
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签

5. Query Optimizer

 Github  来源:Presto 浏览 450 扫码 分享 2020-04-20 22:49:06
  • 5. Query Optimizer

    5. Query Optimizer

    • 5.1. Table Statistics
    • 5.2. Cost in EXPLAIN
    • 5.3. Cost based optimizations
    当前内容版权归 Presto 或其关联方所有，如需对内容或内容相关联开源项目进行关注与资助，请访问 Presto .
    上一篇:
    下一篇:
    • 书签
    • 添加书签 移除书签
    • Presto v0.289 Documentation
    • Presto v0.285 Documentation
    • Presto v0.280 Documentation
    • Presto 0.275 Documentation
    • Presto 0.272.1 Documentation
    • Presto 0.268 Documentation
    • Presto 0.257 Documentation
    • Presto 0.245.1 Documentation
    • Presto 0.242 Documentation
    • Presto 0.237 Documentation
    • Presto 0.236 Documentation
    • Presto 0.234 Documentation
    • Presto 0.229 Documentation
    • Presto 0.221 Documentation
    • Presto 0.220 Documentation
    • Presto 0.206 Documentation
    • 1. Overview
      • 1.1. Use Cases
      • 1.2. Presto Concepts
    • 2. Installation
      • 2.1. Deploying Presto
      • 2.2. Command Line Interface
      • 2.3. JDBC Driver
      • 2.4. Benchmark Driver
      • 2.5. Web Connector for Tableau
    • 3. Security
      • 3.1. Coordinator Kerberos Authentication
      • 3.2. CLI Kerberos Authentication
      • 3.3. LDAP Authentication
      • 3.4. Java Keystores and Truststores
      • 3.5. Built-in System Access Control
      • 3.6. Secure Internal Communication
    • 4. Administration
      • 4.1. Web Interface
      • 4.2. Tuning Presto
      • 4.3. Properties Reference
      • 4.4. Spill to Disk
      • 4.5. Resource Groups
      • 4.6. Session Property Managers
      • 4.7. Function Namespace Managers
      • 4.8. Distributed sort
      • 4.9. Presto Verifier
    • 5. Query Optimizer
      • 5.1. Table Statistics
      • 5.2. Cost in EXPLAIN
      • 5.3. Cost based optimizations
    • 6. Connectors
      • 6.1. Accumulo Connector
      • 6.2. Black Hole Connector
      • 6.3. Cassandra Connector
      • 6.4. Druid Connector
      • 6.5. Elasticsearch Connector
      • 6.6. Hive Connector
      • 6.7. Hive Security Configuration
      • 6.8. JMX Connector
      • 6.9. Kafka Connector
      • 6.10. Kafka Connector Tutorial
      • 6.11. Kudu Connector
      • 6.12. Local File Connector
      • 6.13. Memory Connector
      • 6.14. MongoDB Connector
      • 6.15. MySQL Connector
      • 6.16. Pinot Connector
      • 6.17. PostgreSQL Connector
      • 6.18. Redis Connector
      • 6.19. Redshift Connector
      • 6.20. SQL Server Connector
      • 6.21. System Connector
      • 6.22. Thrift Connector
      • 6.23. TPCDS Connector
      • 6.24. TPCH Connector
    • 7. Functions and Operators
      • 7.1. Logical Operators
      • 7.2. Comparison Functions and Operators
      • 7.3. Conditional Expressions
      • 7.4. Lambda Expressions
      • 7.5. Conversion Functions
      • 7.6. Mathematical Functions and Operators
      • 7.7. Bitwise Functions
      • 7.8. Decimal Functions and Operators
      • 7.9. String Functions and Operators
      • 7.10. Regular Expression Functions
      • 7.11. Binary Functions and Operators
      • 7.12. JSON Functions and Operators
      • 7.13. Date and Time Functions and Operators
      • 7.14. Aggregate Functions
      • 7.15. Window Functions
      • 7.16. Array Functions and Operators
      • 7.17. Map Functions and Operators
      • 7.18. URL Functions
      • 7.19. IP Functions
      • 7.20. Geospatial Functions
      • 7.21. HyperLogLog Functions
      • 7.22. KHyperLogLog Functions
      • 7.23. Quantile Digest Functions
      • 7.24. Color Functions
      • 7.25. Session Information
      • 7.26. Teradata Functions
    • 8. SQL Language
      • 8.1. Data Types
      • 8.2. Reserved Keywords
    • 9. SQL Statement Syntax
      • 9.1. ALTER FUNCTION
      • 9.2. ALTER SCHEMA
      • 9.3. ALTER TABLE
      • 9.4. ANALYZE
      • 9.5. CALL
      • 9.6. COMMIT
      • 9.7. CREATE FUNCTION
      • 9.8. CREATE ROLE
      • 9.9. CREATE SCHEMA
      • 9.10. CREATE TABLE
      • 9.11. CREATE TABLE AS
      • 9.12. CREATE VIEW
      • 9.13. DEALLOCATE PREPARE
      • 9.14. DELETE
      • 9.15. DESCRIBE
      • 9.16. DESCRIBE INPUT
      • 9.17. DESCRIBE OUTPUT
      • 9.18. DROP FUNCTION
      • 9.19. DROP ROLE
      • 9.20. DROP SCHEMA
      • 9.21. DROP TABLE
      • 9.22. DROP VIEW
      • 9.23. EXECUTE
      • 9.24. EXPLAIN
      • 9.25. EXPLAIN ANALYZE
      • 9.26. GRANT
      • 9.27. GRANT ROLES
      • 9.28. INSERT
      • 9.29. PREPARE
      • 9.30. RESET SESSION
      • 9.31. REVOKE
      • 9.32. REVOKE ROLES
      • 9.33. ROLLBACK
      • 9.34. SELECT
      • 9.35. SET ROLE
      • 9.36. SET SESSION
      • 9.37. SHOW CATALOGS
      • 9.38. SHOW COLUMNS
      • 9.39. SHOW CREATE TABLE
      • 9.40. SHOW CREATE VIEW
      • 9.41. SHOW FUNCTIONS
      • 9.42. SHOW GRANTS
      • 9.43. SHOW ROLE GRANTS
      • 9.44. SHOW ROLES
      • 9.45. SHOW SCHEMAS
      • 9.46. SHOW SESSION
      • 9.47. SHOW STATS
      • 9.48. SHOW TABLES
      • 9.49. START TRANSACTION
      • 9.50. USE
      • 9.51. VALUES
    • 10. Migration
      • 10.1. Migrating From Hive
    • 11. Developer Guide
      • 11.1. SPI Overview
      • 11.2. Connectors
      • 11.3. Example HTTP Connector
      • 11.4. Types
      • 11.5. Functions
      • 11.6. System Access Control
      • 11.7. Password Authenticator
      • 11.8. Event Listener
    • 12. Release Notes
      • 12.1. Release 0.234
      • 12.2. Release 0.233.1
      • 12.3. Release 0.233
      • 12.4. Release 0.232
      • 12.5. Release 0.231
      • 12.6. Release 0.230
      • 12.7. Release 0.229
      • 12.8. Release 0.228
      • 12.9. Release 0.227
      • 12.10. Release 0.226
      • 12.11. Release 0.225
      • 12.12. Release 0.224
      • 12.13. Release 0.223
      • 12.14. Release 0.222
      • 12.15. Release 0.221
      • 12.16. Release 0.220
      • 12.17. Release 0.219
      • 12.18. Release 0.218
      • 12.19. Release 0.217
      • 12.20. Release 0.216
      • 12.21. Release 0.215
      • 12.22. Release 0.214
      • 12.23. Release 0.213
      • 12.24. Release 0.212
      • 12.25. Release 0.211
      • 12.26. Release 0.210
      • 12.27. Release 0.209
      • 12.28. Release 0.208
      • 12.29. Release 0.207
      • 12.30. Release 0.206
      • 12.31. Release 0.205
      • 12.32. Release 0.204
      • 12.33. Release 0.203
      • 12.34. Release 0.202
      • 12.35. Release 0.201
      • 12.36. Release 0.200
      • 12.37. Release 0.199
      • 12.38. Release 0.198
      • 12.39. Release 0.197
      • 12.40. Release 0.196
      • 12.41. Release 0.195
      • 12.42. Release 0.194
      • 12.43. Release 0.193
      • 12.44. Release 0.192
      • 12.45. Release 0.191
      • 12.46. Release 0.190
      • 12.47. Release 0.189
      • 12.48. Release 0.188
      • 12.49. Release 0.187
      • 12.50. Release 0.186
      • 12.51. Release 0.185
      • 12.52. Release 0.184
      • 12.53. Release 0.183
      • 12.54. Release 0.182
      • 12.55. Release 0.181
      • 12.56. Release 0.180
      • 12.57. Release 0.179
      • 12.58. Release 0.178
      • 12.59. Release 0.177
      • 12.60. Release 0.176
      • 12.61. Release 0.175
      • 12.62. Release 0.174
      • 12.63. Release 0.173
      • 12.64. Release 0.172
      • 12.65. Release 0.171
      • 12.66. Release 0.170
      • 12.67. Release 0.169
      • 12.68. Release 0.168
      • 12.69. Release 0.167
      • 12.70. Release 0.166
      • 12.71. Release 0.165
      • 12.72. Release 0.164
      • 12.73. Release 0.163
      • 12.74. Release 0.162
      • 12.75. Release 0.161
      • 12.76. Release 0.160
      • 12.77. Release 0.159
      • 12.78. Release 0.158
      • 12.79. Release 0.157.1
      • 12.80. Release 0.157
      • 12.81. Release 0.156
      • 12.82. Release 0.155
      • 12.83. Release 0.154
      • 12.84. Release 0.153
      • 12.85. Release 0.152.3
      • 12.86. Release 0.152.2
      • 12.87. Release 0.152.1
      • 12.88. Release 0.152
      • 12.89. Release 0.151
      • 12.90. Release 0.150
      • 12.91. Release 0.149
      • 12.92. Release 0.148
      • 12.93. Release 0.147
      • 12.94. Release 0.146
      • 12.95. Release 0.145
      • 12.96. Release 0.144.7
      • 12.97. Release 0.144.6
      • 12.98. Release 0.144.5
      • 12.99. Release 0.144.4
      • 12.100. Release 0.144.3
      • 12.101. Release 0.144.2
      • 12.102. Release 0.144.1
      • 12.103. Release 0.144
      • 12.104. Release 0.143
      • 12.105. Release 0.142
      • 12.106. Release 0.141
      • 12.107. Release 0.140
      • 12.108. Release 0.139
      • 12.109. Release 0.138
      • 12.110. Release 0.137
      • 12.111. Release 0.136
      • 12.112. Release 0.135
      • 12.113. Release 0.134
      • 12.114. Release 0.133
      • 12.115. Release 0.132
      • 12.116. Release 0.131
      • 12.117. Release 0.130
      • 12.118. Release 0.129
      • 12.119. Release 0.128
      • 12.120. Release 0.127
      • 12.121. Release 0.126
      • 12.122. Release 0.125
      • 12.123. Release 0.124
      • 12.124. Release 0.123
      • 12.125. Release 0.122
      • 12.126. Release 0.121
      • 12.127. Release 0.120
      • 12.128. Release 0.119
      • 12.129. Release 0.118
      • 12.130. Release 0.117
      • 12.131. Release 0.116
      • 12.132. Release 0.115
      • 12.133. Release 0.114
      • 12.134. Release 0.113
      • 12.135. Release 0.112
      • 12.136. Release 0.111
      • 12.137. Release 0.110
      • 12.138. Release 0.109
      • 12.139. Release 0.108
      • 12.140. Release 0.107
      • 12.141. Release 0.106
      • 12.142. Release 0.105
      • 12.143. Release 0.104
      • 12.144. Release 0.103
      • 12.145. Release 0.102
      • 12.146. Release 0.101
      • 12.147. Release 0.100
      • 12.148. Release 0.99
      • 12.149. Release 0.98
      • 12.150. Release 0.97
      • 12.151. Release 0.96
      • 12.152. Release 0.95
      • 12.153. Release 0.94
      • 12.154. Release 0.93
      • 12.155. Release 0.92
      • 12.156. Release 0.91
      • 12.157. Release 0.90
      • 12.158. Release 0.89
      • 12.159. Release 0.88
      • 12.160. Release 0.87
      • 12.161. Release 0.86
      • 12.162. Release 0.85
      • 12.163. Release 0.84
      • 12.164. Release 0.83
      • 12.165. Release 0.82
      • 12.166. Release 0.81
      • 12.167. Release 0.80
      • 12.168. Release 0.79
      • 12.169. Release 0.78
      • 12.170. Release 0.77
      • 12.171. Release 0.76
      • 12.172. Release 0.75
      • 12.173. Release 0.74
      • 12.174. Release 0.73
      • 12.175. Release 0.72
      • 12.176. Release 0.71
      • 12.177. Release 0.70
      • 12.178. Release 0.69
      • 12.179. Release 0.68
      • 12.180. Release 0.67
      • 12.181. Release 0.66
      • 12.182. Release 0.65
      • 12.183. Release 0.64
      • 12.184. Release 0.63
      • 12.185. Release 0.62
      • 12.186. Release 0.61
      • 12.187. Release 0.60
      • 12.188. Release 0.59
      • 12.189. Release 0.58
      • 12.190. Release 0.57
      • 12.191. Release 0.56
      • 12.192. Release 0.55
      • 12.193. Release 0.54
    暂无相关搜索结果！

      本文档使用 BookStack 构建

      展开/收起文章目录

      分享，让知识传承更久远

      文章二维码

      手机扫一扫，轻松掌上读

      文档下载

      • 普通下载
      • 下载码下载(免登录无限下载)
      你与大神的距离，只差一个APP
      APP下载
      请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
      PDF文档 EPUB文档 MOBI文档
      温馨提示 每天每在网站阅读学习一分钟时长可下载一本电子书，每天连续签到可增加阅读时长
      下载码方式下载：免费、免登录、无限制。 免费获取下载码

      微信小程序阅读

      BookChat 微信小程序阅读
      您与他人的薪资差距，只差一个随时随地学习的小程序

      书签列表

        阅读记录

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