Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

共进行三种查询:带值过滤的原始数据查询;带值过滤的聚合查询(Count和Max_Value两种),带值过滤的group by查询(Count和Max_Value两种+10-1000不同粒度)

实验结果

Image Added

如上表所示,可以发现,当选择率较低时,查询执行时间有明显的提升,选择率大于50%以后与原有时间持平。

...