思维导图备注

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

6. Query Optimizer

 Github  来源:Facebook 浏览 496 扫码 分享 2020-10-11 15:08:28
  • 6. Query Optimizer

    6. Query Optimizer

    • 6.1. Table Statistics
    • 6.2. Cost in EXPLAIN
    • 6.3. Cost based optimizations
    当前内容版权归 Facebook 或其关联方所有，如需对内容或内容相关联开源项目进行关注与资助，请访问 Facebook .
    上一篇:
    下一篇:
    • 书签
    • 添加书签 移除书签
    • 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
      • 2.6. Executing Presto on Spark
    • 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
      • 3.7. Authorization
    • 4. Administration
      • 4.1. Web Interface
      • 4.2. Tuning Presto
      • 4.3. Properties Reference
      • 4.4. Spill to Disk
      • 4.5. Exchange Materialization
      • 4.6. Resource Groups
      • 4.7. Session Property Managers
      • 4.8. Function Namespace Managers
      • 4.9. Distributed sort
      • 4.10. Presto Verifier
    • 5. Cache
      • 5.1. Alluxio Cache Service
    • 6. Query Optimizer
      • 6.1. Table Statistics
      • 6.2. Cost in EXPLAIN
      • 6.3. Cost based optimizations
    • 7. Connectors
      • 7.1. Accumulo Connector
      • 7.2. Black Hole Connector
      • 7.3. Cassandra Connector
      • 7.4. Druid Connector
      • 7.5. Elasticsearch Connector
      • 7.6. Hive Connector
      • 7.7. Hive Security Configuration
      • 7.8. JMX Connector
      • 7.9. Kafka Connector
      • 7.10. Kafka Connector Tutorial
      • 7.11. Kudu Connector
      • 7.12. Local File Connector
      • 7.13. Memory Connector
      • 7.14. MongoDB Connector
      • 7.15. MySQL Connector
      • 7.16. Oracle Connector
      • 7.17. Pinot Connector
      • 7.18. PostgreSQL Connector
      • 7.19. Redis Connector
      • 7.20. Redshift Connector
      • 7.21. SQL Server Connector
      • 7.22. System Connector
      • 7.23. Thrift Connector
      • 7.24. TPCDS Connector
      • 7.25. TPCH Connector
    • 8. Functions and Operators
      • 8.1. Logical Operators
      • 8.2. Comparison Functions and Operators
      • 8.3. Conditional Expressions
      • 8.4. Lambda Expressions
      • 8.5. Conversion Functions
      • 8.6. Mathematical Functions and Operators
      • 8.7. Bitwise Functions
      • 8.8. Decimal Functions and Operators
      • 8.9. String Functions and Operators
      • 8.10. Regular Expression Functions
      • 8.11. Binary Functions and Operators
      • 8.12. JSON Functions and Operators
      • 8.13. Date and Time Functions and Operators
      • 8.14. Aggregate Functions
      • 8.15. Window Functions
      • 8.16. Array Functions and Operators
      • 8.17. Map Functions and Operators
      • 8.18. URL Functions
      • 8.19. IP Functions
      • 8.20. Geospatial Functions
      • 8.21. HyperLogLog Functions
      • 8.22. KHyperLogLog Functions
      • 8.23. Quantile Digest Functions
      • 8.24. Color Functions
      • 8.25. Session Information
      • 8.26. Teradata Functions
      • 8.27. Internationalization Functions
    • 9. SQL Language
      • 9.1. Data Types
      • 9.2. Reserved Keywords
    • 10. SQL Statement Syntax
      • 10.1. ALTER FUNCTION
      • 10.2. ALTER SCHEMA
      • 10.3. ALTER TABLE
      • 10.4. ANALYZE
      • 10.5. CALL
      • 10.6. COMMIT
      • 10.7. CREATE FUNCTION
      • 10.8. CREATE ROLE
      • 10.9. CREATE SCHEMA
      • 10.10. CREATE TABLE
      • 10.11. CREATE TABLE AS
      • 10.12. CREATE VIEW
      • 10.13. DEALLOCATE PREPARE
      • 10.14. DELETE
      • 10.15. DESCRIBE
      • 10.16. DESCRIBE INPUT
      • 10.17. DESCRIBE OUTPUT
      • 10.18. DROP FUNCTION
      • 10.19. DROP ROLE
      • 10.20. DROP SCHEMA
      • 10.21. DROP TABLE
      • 10.22. DROP VIEW
      • 10.23. EXECUTE
      • 10.24. EXPLAIN
      • 10.25. EXPLAIN ANALYZE
      • 10.26. GRANT
      • 10.27. GRANT ROLES
      • 10.28. INSERT
      • 10.29. PREPARE
      • 10.30. RESET SESSION
      • 10.31. REVOKE
      • 10.32. REVOKE ROLES
      • 10.33. ROLLBACK
      • 10.34. SELECT
      • 10.35. SET ROLE
      • 10.36. SET SESSION
      • 10.37. SHOW CATALOGS
      • 10.38. SHOW COLUMNS
      • 10.39. SHOW CREATE FUNCTION
      • 10.40. SHOW CREATE TABLE
      • 10.41. SHOW CREATE VIEW
      • 10.42. SHOW FUNCTIONS
      • 10.43. SHOW GRANTS
      • 10.44. SHOW ROLE GRANTS
      • 10.45. SHOW ROLES
      • 10.46. SHOW SCHEMAS
      • 10.47. SHOW SESSION
      • 10.48. SHOW STATS
      • 10.49. SHOW TABLES
      • 10.50. START TRANSACTION
      • 10.51. USE
      • 10.52. VALUES
    • 11. Migration
      • 11.1. Migrating From Hive
    • 12. Developer Guide
      • 12.1. SPI Overview
      • 12.2. Connectors
      • 12.3. Example HTTP Connector
      • 12.4. Types
      • 12.5. Functions
      • 12.6. System Access Control
      • 12.7. Password Authenticator
      • 12.8. Event Listener
    • 13. Release Notes
      • 13.1. Release 0.242
      • 13.2. Release 0.241
      • 13.3. Release 0.240
      • 13.4. Release 0.239.2
      • 13.5. Release 0.239.1
      • 13.6. Release 0.239
      • 13.7. Release 0.238.3
      • 13.8. Release 0.238.2
      • 13.9. Release 0.238
      • 13.10. Release 0.237
      • 13.11. Release 0.236
      • 13.12. Release 0.235.1
      • 13.13. Release 0.235
      • 13.14. Release 0.234.3
      • 13.15. Release 0.234.2
      • 13.16. Release 0.234.1
      • 13.17. Release 0.234
      • 13.18. Release 0.233.1
      • 13.19. Release 0.233
      • 13.20. Release 0.232
      • 13.21. Release 0.231
      • 13.22. Release 0.230
      • 13.23. Release 0.229
      • 13.24. Release 0.228
      • 13.25. Release 0.227
      • 13.26. Release 0.226
      • 13.27. Release 0.225
      • 13.28. Release 0.224
      • 13.29. Release 0.223
      • 13.30. Release 0.222
      • 13.31. Release 0.221
      • 13.32. Release 0.220
      • 13.33. Release 0.219
      • 13.34. Release 0.218
      • 13.35. Release 0.217
      • 13.36. Release 0.216
      • 13.37. Release 0.215
      • 13.38. Release 0.214
      • 13.39. Release 0.213
      • 13.40. Release 0.212
      • 13.41. Release 0.211
      • 13.42. Release 0.210
      • 13.43. Release 0.209
      • 13.44. Release 0.208
      • 13.45. Release 0.207
      • 13.46. Release 0.206
      • 13.47. Release 0.205
      • 13.48. Release 0.204
      • 13.49. Release 0.203
      • 13.50. Release 0.202
      • 13.51. Release 0.201
      • 13.52. Release 0.200
      • 13.53. Release 0.199
      • 13.54. Release 0.198
      • 13.55. Release 0.197
      • 13.56. Release 0.196
      • 13.57. Release 0.195
      • 13.58. Release 0.194
      • 13.59. Release 0.193
      • 13.60. Release 0.192
      • 13.61. Release 0.191
      • 13.62. Release 0.190
      • 13.63. Release 0.189
      • 13.64. Release 0.188
      • 13.65. Release 0.187
      • 13.66. Release 0.186
      • 13.67. Release 0.185
      • 13.68. Release 0.184
      • 13.69. Release 0.183
      • 13.70. Release 0.182
      • 13.71. Release 0.181
      • 13.72. Release 0.180
      • 13.73. Release 0.179
      • 13.74. Release 0.178
      • 13.75. Release 0.177
      • 13.76. Release 0.176
      • 13.77. Release 0.175
      • 13.78. Release 0.174
      • 13.79. Release 0.173
      • 13.80. Release 0.172
      • 13.81. Release 0.171
      • 13.82. Release 0.170
      • 13.83. Release 0.169
      • 13.84. Release 0.168
      • 13.85. Release 0.167
      • 13.86. Release 0.166
      • 13.87. Release 0.165
      • 13.88. Release 0.164
      • 13.89. Release 0.163
      • 13.90. Release 0.162
      • 13.91. Release 0.161
      • 13.92. Release 0.160
      • 13.93. Release 0.159
      • 13.94. Release 0.158
      • 13.95. Release 0.157.1
      • 13.96. Release 0.157
      • 13.97. Release 0.156
      • 13.98. Release 0.155
      • 13.99. Release 0.154
      • 13.100. Release 0.153
      • 13.101. Release 0.152.3
      • 13.102. Release 0.152.2
      • 13.103. Release 0.152.1
      • 13.104. Release 0.152
      • 13.105. Release 0.151
      • 13.106. Release 0.150
      • 13.107. Release 0.149
      • 13.108. Release 0.148
      • 13.109. Release 0.147
      • 13.110. Release 0.146
      • 13.111. Release 0.145
      • 13.112. Release 0.144.7
      • 13.113. Release 0.144.6
      • 13.114. Release 0.144.5
      • 13.115. Release 0.144.4
      • 13.116. Release 0.144.3
      • 13.117. Release 0.144.2
      • 13.118. Release 0.144.1
      • 13.119. Release 0.144
      • 13.120. Release 0.143
      • 13.121. Release 0.142
      • 13.122. Release 0.141
      • 13.123. Release 0.140
      • 13.124. Release 0.139
      • 13.125. Release 0.138
      • 13.126. Release 0.137
      • 13.127. Release 0.136
      • 13.128. Release 0.135
      • 13.129. Release 0.134
      • 13.130. Release 0.133
      • 13.131. Release 0.132
      • 13.132. Release 0.131
      • 13.133. Release 0.130
      • 13.134. Release 0.129
      • 13.135. Release 0.128
      • 13.136. Release 0.127
      • 13.137. Release 0.126
      • 13.138. Release 0.125
      • 13.139. Release 0.124
      • 13.140. Release 0.123
      • 13.141. Release 0.122
      • 13.142. Release 0.121
      • 13.143. Release 0.120
      • 13.144. Release 0.119
      • 13.145. Release 0.118
      • 13.146. Release 0.117
      • 13.147. Release 0.116
      • 13.148. Release 0.115
      • 13.149. Release 0.114
      • 13.150. Release 0.113
      • 13.151. Release 0.112
      • 13.152. Release 0.111
      • 13.153. Release 0.110
      • 13.154. Release 0.109
      • 13.155. Release 0.108
      • 13.156. Release 0.107
      • 13.157. Release 0.106
      • 13.158. Release 0.105
      • 13.159. Release 0.104
      • 13.160. Release 0.103
      • 13.161. Release 0.102
      • 13.162. Release 0.101
      • 13.163. Release 0.100
      • 13.164. Release 0.99
      • 13.165. Release 0.98
      • 13.166. Release 0.97
      • 13.167. Release 0.96
      • 13.168. Release 0.95
      • 13.169. Release 0.94
      • 13.170. Release 0.93
      • 13.171. Release 0.92
      • 13.172. Release 0.91
      • 13.173. Release 0.90
      • 13.174. Release 0.89
      • 13.175. Release 0.88
      • 13.176. Release 0.87
      • 13.177. Release 0.86
      • 13.178. Release 0.85
      • 13.179. Release 0.84
      • 13.180. Release 0.83
      • 13.181. Release 0.82
      • 13.182. Release 0.81
      • 13.183. Release 0.80
      • 13.184. Release 0.79
      • 13.185. Release 0.78
      • 13.186. Release 0.77
      • 13.187. Release 0.76
      • 13.188. Release 0.75
      • 13.189. Release 0.74
      • 13.190. Release 0.73
      • 13.191. Release 0.72
      • 13.192. Release 0.71
      • 13.193. Release 0.70
      • 13.194. Release 0.69
      • 13.195. Release 0.68
      • 13.196. Release 0.67
      • 13.197. Release 0.66
      • 13.198. Release 0.65
      • 13.199. Release 0.64
      • 13.200. Release 0.63
      • 13.201. Release 0.62
      • 13.202. Release 0.61
      • 13.203. Release 0.60
      • 13.204. Release 0.59
      • 13.205. Release 0.58
      • 13.206. Release 0.57
      • 13.207. Release 0.56
      • 13.208. Release 0.55
      • 13.209. Release 0.54
    暂无相关搜索结果！

      本文档使用 BookStack 构建

      展开/收起文章目录

      分享，让知识传承更久远

      文章二维码

      手机扫一扫，轻松掌上读

      文档下载

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

      微信小程序阅读

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

      书签列表

        阅读记录

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