V2EX = way to explore
V2EX 是一个关于分享和探索的地方
现在注册
已注册用户请  登录
MySQL 5.5 Community Server
MySQL 5.6 Community Server
Percona Configuration Wizard
XtraBackup 搭建主从复制
Great Sites on MySQL
Percona
MySQL Performance Blog
Severalnines
推荐管理工具
Sequel Pro
phpMyAdmin
推荐书目
MySQL Cookbook
MySQL 相关项目
MariaDB
Drizzle
参考文档
http://mysql-python.sourceforge.net/MySQLdb.html
virus94
V2EX  ›  MySQL

MySQL 手册中的 dive into 该怎么理解?

  •  
  •   virus94 · 2019-01-07 17:17:17 +08:00 · 3674 次点击
    这是一个创建于 2182 天前的主题,其中的信息可能已经有所发展或是发生改变。

    在看 mysql5.7 的手册,看到 Optimization 章节时,发现这一段

     • Otherwise, any index on col_name is nonunique and the optimizer can estimate the row count for each
    range using dives into the index or index statistics.
    
    With index dives, the optimizer makes a dive at each end of a range and uses the number of rows in the
    range as the estimate. For example, the expression col_name IN (10, 20, 30) has three equality
    ranges and the optimizer makes two dives per range to generate a row estimate. Each pair of dives yields
    an estimate of the number of rows that have the given value.
    
      Index dives provide accurate row estimates, but as the number of comparison values in the expression
    increases, the optimizer takes longer to generate a row estimate. Use of index statistics is less accurate
    than index dives but permits faster row estimation for large value lists.
    

    查了一下有道词典,dive 翻译为潜水,俯冲,知乎上有个 DBA 翻译了这个章节,也翻译成潜水,总感觉不对.

    请教各位,这里面的 dive 和 dive into 该如何理解?

    3 条回复    2019-03-24 16:54:06 +08:00
    mywaiting
        1
    mywaiting  
       2019-01-07 17:23:27 +08:00   ❤️ 1
    dive into 理解为“深入”?
    fkdog
        2
    fkdog  
       2019-01-07 17:36:29 +08:00
    不止 dive into,还有 dig into,
    isrfr
        3
    isrfr  
       2019-03-24 16:54:06 +08:00 via Android
    植入?
    关于   ·   帮助文档   ·   博客   ·   API   ·   FAQ   ·   实用小工具   ·   953 人在线   最高记录 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 24ms · UTC 20:59 · PVG 04:59 · LAX 12:59 · JFK 15:59
    Developed with CodeLauncher
    ♥ Do have faith in what you're doing.