This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new fe8ccb5a419 add list of operators and functions for index acceleration
(#1259)
fe8ccb5a419 is described below
commit fe8ccb5a419ec38ea5e942c296477bf886ece0ab
Author: Kang <kxiao.ti...@gmail.com>
AuthorDate: Fri Nov 1 23:54:16 2024 +0800
add list of operators and functions for index acceleration (#1259)
# Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [x] 2.0
# Languages
- [x] Chinese
- [x] English
---
docs/table-design/index/index-overview.md | 31 +++++++++++++++----
.../current/table-design/index/index-overview.md | 36 ++++++++++++++++------
.../table-design/index/index-overview.md | 33 ++++++++++++++------
.../table-design/index/index-overview.md | 36 ++++++++++++++++------
.../table-design/index/index-overview.md | 36 ++++++++++++++++------
.../table-design/index/index-overview.md | 28 +++++++++++++----
.../table-design/index/index-overview.md | 31 +++++++++++++++----
.../table-design/index/index-overview.md | 31 +++++++++++++++----
8 files changed, 202 insertions(+), 60 deletions(-)
diff --git a/docs/table-design/index/index-overview.md
b/docs/table-design/index/index-overview.md
index ef27453a8f8..cb6c6b9efca 100644
--- a/docs/table-design/index/index-overview.md
+++ b/docs/table-design/index/index-overview.md
@@ -39,13 +39,32 @@ From the perspective of accelerating queries and their
principles, Doris indexes
Among the above indexes, the prefix index and ZoneMap index are built-in
indexes automatically maintained by Doris, requiring no user management.
Inverted indexes, BloomFilter indexes, and NGram BloomFilter indexes need to be
manually created and managed by the user based on the scenario.
-| Type | Index | Accelerates Equal | Accelerates Not Equal |
Accelerates Range | Accelerates LIKE | Accelerates MATCH (Keywords, Phrases) |
Advantages | Limitations
|
+- Comparison of characteristics of different types of indexes
+
+| Type | Index | Advantages |
Limitations |
|------------|-------------------|-------------------|-----------------------|-------------------|------------------|----------------------------------------|-------------------------------------------|-------------------------------------------|
-| Point Query | Prefix Index | YES | YES
| YES | NO | NO
| Most commonly used filter condition | Only one prefix index per table
|
-| Point Query | Inverted Index | YES | YES
| YES | COMING | YES
| Supports tokenization and keyword matching, can build index on any column,
multi-condition combination | Large index storage space, similar to raw data |
-| Skip | ZoneMap Index | YES | YES
| YES | NO | NO
| Built-in index, small index storage space | Only one prefix index per table
|
-| Skip | BloomFilter Index | YES | NO
| NO | NO | NO
| More precise than ZoneMap, small index space | Supports few query types, only
supports equal, not others (not equal, range, LIKE, MATCH) |
-| Skip | NGram BloomFilter | NO | NO
| NO | YES | NO
| Supports LIKE acceleration, small index space | Only supports LIKE
acceleration |
+| Point Query | Prefix Index | Built-in index, best performance |
Only one prefix index per table |
+| Point Query | Inverted Index | Supports tokenization and keyword
matching, building index on any column, multi-condition combination and
accelerating more functions | Large index storage space, similar to raw data |
+| Skip | ZoneMap Index | Built-in index, small index storage space
| Only one prefix index per table |
+| Skip | BloomFilter Index | More precise than ZoneMap, medium index
space | Supports few query types, only supports equal, not others (not equal,
range, LIKE, MATCH) |
+| Skip | NGram BloomFilter | Supports LIKE acceleration, medium index
space | Supports few query types, only supports LIKE acceleration |
+
+- List of operators and functions for index acceleration
+
+| Operator or Function | Prefix Index | Inverted Index | ZoneMap Index |
BloomFilter Index | NGram BloomFilter Index |
+|-------------------------|---------|---------|--------------|-----------------|------------------------|
+| = | YES | YES | YES | YES
| NO |
+| != | YES | YES | NO | NO
| NO |
+| IN | YES | YES | YES | YES
| NO |
+| NOT IN | YES | YES | NO | NO
| NO |
+| >, >=, <, <=, BETWEEN | YES | YES | YES | NO
| NO |
+| IS NULL | YES | YES | YES | NO
| NO |
+| IS NOT NULL | YES | YES | NO | NO
| NO |
+| LIKE | NO | NO | NO | NO
| YES |
+| MATCH, MATCH_* | NO | YES | NO | NO
| NO |
+| array_contains | NO | YES | NO | NO
| NO |
+| array_overlaps | NO | YES | NO | NO
| NO |
+| is_ip_address_in_range | NO | YES | NO | NO
| NO |
## Index Design Guidelines
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/index/index-overview.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/index/index-overview.md
index f6a6fd3c0c6..9e3f1d3d3af 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/index/index-overview.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/index/index-overview.md
@@ -41,15 +41,33 @@ under the License.
上述索引中，前缀索引和 ZoneMap 索引是 Apache Doris 自动维护的内建智能索引，无需用户管理，而倒排索引、BloomFilter
索引、NGram BloomFilter 索引则需要用户自己根据场景选择，手动创建、删除。
-
-| 类型 | 索引 | 加速等于 | 加速不等 | 加速范围 | 加速 LIKE | 加速 MATCH（关键词、短语） | 优点 | 局限 |
-|-----------|-----------|-----------|
-----------|-----------|-----------|-----------|-----------|-----------|
-| 点查索引 | 前缀索引 | YES | YES | YES | NO | NO | 最常用的过滤条件 | 一个表只有一个前缀索引 |
-| 点查索引 | 倒排索引 | YES | YES | YES | COMING | YES | 支持分词和关键词匹配，任意列可建索引，多条件组合 |
索引存储空间较大，与原始数据相当 |
-| 跳数索引 | ZoneMap 索引 | YES | YES | YES | NO | NO | 内置索引，索引存储空间小 | N/A |
-| 跳数索引 | BloomFilter 索引 | YES | NO | NO | NO | NO | 比 ZoneMap 更精细，索引空间较小 |
支持的查询类型少，只支持等于，不支持其他（不等、范围、LIKE、MATCH） |
-| 跳数索引 | NGram BloomFilter 索引 | NO | NO | NO | YES | NO | 支持 LIKE 加速，索引空间较小 |
只支持 LIKE 加速 |
-
+- 各种类型索引特点对比
+
+| 类型 | 索引 | 优点 | 局限
|
+|--------|------------------------|------------------------------------------|--------------------------------|
+| 点查索引 | 前缀索引 | 内置索引，性能最好 |
一个表只有一组前缀索引 |
+| 点查索引 | 倒排索引 | 支持分词和关键词匹配，任意列可建索引，多条件组合，持续增加函数加速 |
索引存储空间较大，与原始数据相当 |
+| 跳数索引 | ZoneMap 索引 | 内置索引，索引存储空间小 |
支持的查询类型少，只支持等于、范围 |
+| 跳数索引 | BloomFilter 索引 | 比 ZoneMap 更精细，索引空间中等 |
支持的查询类型少，只支持等于 |
+| 跳数索引 | NGram BloomFilter 索引 | 支持 LIKE 加速，索引空间中等 |
支持的查询类型少，只支持 LIKE 加速 |
+
+
+- 索引加速的运算符和函数列表
+
+| 运算符 / 函数 | 前缀索引 | 倒排索引 | ZoneMap 索引 | BloomFilter 索引 | NGram
BloomFilter 索引 |
+|-------------------------|---------|---------|--------------|-----------------|------------------------|
+| = | YES | YES | YES | YES
| NO |
+| != | YES | YES | NO | NO
| NO |
+| IN | YES | YES | YES | YES
| NO |
+| NOT IN | YES | YES | NO | NO
| NO |
+| >, >=, <, <=, BETWEEN | YES | YES | YES | NO
| NO |
+| IS NULL | YES | YES | YES | NO
| NO |
+| IS NOT NULL | YES | YES | NO | NO
| NO |
+| LIKE | NO | NO | NO | NO
| YES |
+| MATCH, MATCH_* | NO | YES | NO | NO
| NO |
+| array_contains | NO | YES | NO | NO
| NO |
+| array_overlaps | NO | YES | NO | NO
| NO |
+| is_ip_address_in_range | NO | YES | NO | NO
| NO |
## 索引设计指南
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/index/index-overview.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/index/index-overview.md
index f6a6fd3c0c6..6f46a4fe65e 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/index/index-overview.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/index/index-overview.md
@@ -41,15 +41,30 @@ under the License.
上述索引中，前缀索引和 ZoneMap 索引是 Apache Doris 自动维护的内建智能索引，无需用户管理，而倒排索引、BloomFilter
索引、NGram BloomFilter 索引则需要用户自己根据场景选择，手动创建、删除。
-
-| 类型 | 索引 | 加速等于 | 加速不等 | 加速范围 | 加速 LIKE | 加速 MATCH（关键词、短语） | 优点 | 局限 |
-|-----------|-----------|-----------|
-----------|-----------|-----------|-----------|-----------|-----------|
-| 点查索引 | 前缀索引 | YES | YES | YES | NO | NO | 最常用的过滤条件 | 一个表只有一个前缀索引 |
-| 点查索引 | 倒排索引 | YES | YES | YES | COMING | YES | 支持分词和关键词匹配，任意列可建索引，多条件组合 |
索引存储空间较大，与原始数据相当 |
-| 跳数索引 | ZoneMap 索引 | YES | YES | YES | NO | NO | 内置索引，索引存储空间小 | N/A |
-| 跳数索引 | BloomFilter 索引 | YES | NO | NO | NO | NO | 比 ZoneMap 更精细，索引空间较小 |
支持的查询类型少，只支持等于，不支持其他（不等、范围、LIKE、MATCH） |
-| 跳数索引 | NGram BloomFilter 索引 | NO | NO | NO | YES | NO | 支持 LIKE 加速，索引空间较小 |
只支持 LIKE 加速 |
-
+- 各种类型索引特点对比
+
+| 类型 | 索引 | 优点 | 局限
|
+|--------|------------------------|------------------------------------------|--------------------------------|
+| 点查索引 | 前缀索引 | 内置索引，性能最好 |
一个表只有一组前缀索引 |
+| 点查索引 | 倒排索引 | 支持分词和关键词匹配，任意列可建索引，多条件组合，持续增加函数加速 |
索引存储空间较大，与原始数据相当 |
+| 跳数索引 | ZoneMap 索引 | 内置索引，索引存储空间小 |
支持的查询类型少，只支持等于、范围 |
+| 跳数索引 | BloomFilter 索引 | 比 ZoneMap 更精细，索引空间中等 |
支持的查询类型少，只支持等于 |
+| 跳数索引 | NGram BloomFilter 索引 | 支持 LIKE 加速，索引空间中等 |
支持的查询类型少，只支持 LIKE 加速 |
+
+
+- 索引加速的运算符和函数列表
+
+| 运算符 / 函数 | 前缀索引 | 倒排索引 | ZoneMap 索引 | BloomFilter 索引 | NGram
BloomFilter 索引 |
+|-------------------------|---------|---------|--------------|-----------------|------------------------|
+| = | YES | YES | YES | YES
| NO |
+| != | YES | YES | NO | NO
| NO |
+| IN | YES | YES | YES | YES
| NO |
+| NOT IN | YES | YES | NO | NO
| NO |
+| >, >=, <, <=, BETWEEN | YES | YES | YES | NO
| NO |
+| IS NULL | YES | YES | YES | NO
| NO |
+| IS NOT NULL | YES | YES | NO | NO
| NO |
+| LIKE | NO | NO | NO | NO
| YES |
+| MATCH, MATCH_* | NO | YES | NO | NO
| NO |
## 索引设计指南
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/index/index-overview.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/index/index-overview.md
index f6a6fd3c0c6..9e3f1d3d3af 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/index/index-overview.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/index/index-overview.md
@@ -41,15 +41,33 @@ under the License.
上述索引中，前缀索引和 ZoneMap 索引是 Apache Doris 自动维护的内建智能索引，无需用户管理，而倒排索引、BloomFilter
索引、NGram BloomFilter 索引则需要用户自己根据场景选择，手动创建、删除。
-
-| 类型 | 索引 | 加速等于 | 加速不等 | 加速范围 | 加速 LIKE | 加速 MATCH（关键词、短语） | 优点 | 局限 |
-|-----------|-----------|-----------|
-----------|-----------|-----------|-----------|-----------|-----------|
-| 点查索引 | 前缀索引 | YES | YES | YES | NO | NO | 最常用的过滤条件 | 一个表只有一个前缀索引 |
-| 点查索引 | 倒排索引 | YES | YES | YES | COMING | YES | 支持分词和关键词匹配，任意列可建索引，多条件组合 |
索引存储空间较大，与原始数据相当 |
-| 跳数索引 | ZoneMap 索引 | YES | YES | YES | NO | NO | 内置索引，索引存储空间小 | N/A |
-| 跳数索引 | BloomFilter 索引 | YES | NO | NO | NO | NO | 比 ZoneMap 更精细，索引空间较小 |
支持的查询类型少，只支持等于，不支持其他（不等、范围、LIKE、MATCH） |
-| 跳数索引 | NGram BloomFilter 索引 | NO | NO | NO | YES | NO | 支持 LIKE 加速，索引空间较小 |
只支持 LIKE 加速 |
-
+- 各种类型索引特点对比
+
+| 类型 | 索引 | 优点 | 局限
|
+|--------|------------------------|------------------------------------------|--------------------------------|
+| 点查索引 | 前缀索引 | 内置索引，性能最好 |
一个表只有一组前缀索引 |
+| 点查索引 | 倒排索引 | 支持分词和关键词匹配，任意列可建索引，多条件组合，持续增加函数加速 |
索引存储空间较大，与原始数据相当 |
+| 跳数索引 | ZoneMap 索引 | 内置索引，索引存储空间小 |
支持的查询类型少，只支持等于、范围 |
+| 跳数索引 | BloomFilter 索引 | 比 ZoneMap 更精细，索引空间中等 |
支持的查询类型少，只支持等于 |
+| 跳数索引 | NGram BloomFilter 索引 | 支持 LIKE 加速，索引空间中等 |
支持的查询类型少，只支持 LIKE 加速 |
+
+
+- 索引加速的运算符和函数列表
+
+| 运算符 / 函数 | 前缀索引 | 倒排索引 | ZoneMap 索引 | BloomFilter 索引 | NGram
BloomFilter 索引 |
+|-------------------------|---------|---------|--------------|-----------------|------------------------|
+| = | YES | YES | YES | YES
| NO |
+| != | YES | YES | NO | NO
| NO |
+| IN | YES | YES | YES | YES
| NO |
+| NOT IN | YES | YES | NO | NO
| NO |
+| >, >=, <, <=, BETWEEN | YES | YES | YES | NO
| NO |
+| IS NULL | YES | YES | YES | NO
| NO |
+| IS NOT NULL | YES | YES | NO | NO
| NO |
+| LIKE | NO | NO | NO | NO
| YES |
+| MATCH, MATCH_* | NO | YES | NO | NO
| NO |
+| array_contains | NO | YES | NO | NO
| NO |
+| array_overlaps | NO | YES | NO | NO
| NO |
+| is_ip_address_in_range | NO | YES | NO | NO
| NO |
## 索引设计指南
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/index/index-overview.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/index/index-overview.md
index f6a6fd3c0c6..9e3f1d3d3af 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/index/index-overview.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/index/index-overview.md
@@ -41,15 +41,33 @@ under the License.
上述索引中，前缀索引和 ZoneMap 索引是 Apache Doris 自动维护的内建智能索引，无需用户管理，而倒排索引、BloomFilter
索引、NGram BloomFilter 索引则需要用户自己根据场景选择，手动创建、删除。
-
-| 类型 | 索引 | 加速等于 | 加速不等 | 加速范围 | 加速 LIKE | 加速 MATCH（关键词、短语） | 优点 | 局限 |
-|-----------|-----------|-----------|
-----------|-----------|-----------|-----------|-----------|-----------|
-| 点查索引 | 前缀索引 | YES | YES | YES | NO | NO | 最常用的过滤条件 | 一个表只有一个前缀索引 |
-| 点查索引 | 倒排索引 | YES | YES | YES | COMING | YES | 支持分词和关键词匹配，任意列可建索引，多条件组合 |
索引存储空间较大，与原始数据相当 |
-| 跳数索引 | ZoneMap 索引 | YES | YES | YES | NO | NO | 内置索引，索引存储空间小 | N/A |
-| 跳数索引 | BloomFilter 索引 | YES | NO | NO | NO | NO | 比 ZoneMap 更精细，索引空间较小 |
支持的查询类型少，只支持等于，不支持其他（不等、范围、LIKE、MATCH） |
-| 跳数索引 | NGram BloomFilter 索引 | NO | NO | NO | YES | NO | 支持 LIKE 加速，索引空间较小 |
只支持 LIKE 加速 |
-
+- 各种类型索引特点对比
+
+| 类型 | 索引 | 优点 | 局限
|
+|--------|------------------------|------------------------------------------|--------------------------------|
+| 点查索引 | 前缀索引 | 内置索引，性能最好 |
一个表只有一组前缀索引 |
+| 点查索引 | 倒排索引 | 支持分词和关键词匹配，任意列可建索引，多条件组合，持续增加函数加速 |
索引存储空间较大，与原始数据相当 |
+| 跳数索引 | ZoneMap 索引 | 内置索引，索引存储空间小 |
支持的查询类型少，只支持等于、范围 |
+| 跳数索引 | BloomFilter 索引 | 比 ZoneMap 更精细，索引空间中等 |
支持的查询类型少，只支持等于 |
+| 跳数索引 | NGram BloomFilter 索引 | 支持 LIKE 加速，索引空间中等 |
支持的查询类型少，只支持 LIKE 加速 |
+
+
+- 索引加速的运算符和函数列表
+
+| 运算符 / 函数 | 前缀索引 | 倒排索引 | ZoneMap 索引 | BloomFilter 索引 | NGram
BloomFilter 索引 |
+|-------------------------|---------|---------|--------------|-----------------|------------------------|
+| = | YES | YES | YES | YES
| NO |
+| != | YES | YES | NO | NO
| NO |
+| IN | YES | YES | YES | YES
| NO |
+| NOT IN | YES | YES | NO | NO
| NO |
+| >, >=, <, <=, BETWEEN | YES | YES | YES | NO
| NO |
+| IS NULL | YES | YES | YES | NO
| NO |
+| IS NOT NULL | YES | YES | NO | NO
| NO |
+| LIKE | NO | NO | NO | NO
| YES |
+| MATCH, MATCH_* | NO | YES | NO | NO
| NO |
+| array_contains | NO | YES | NO | NO
| NO |
+| array_overlaps | NO | YES | NO | NO
| NO |
+| is_ip_address_in_range | NO | YES | NO | NO
| NO |
## 索引设计指南
diff --git a/versioned_docs/version-2.0/table-design/index/index-overview.md
b/versioned_docs/version-2.0/table-design/index/index-overview.md
index ef27453a8f8..5720b1968e4 100644
--- a/versioned_docs/version-2.0/table-design/index/index-overview.md
+++ b/versioned_docs/version-2.0/table-design/index/index-overview.md
@@ -39,13 +39,29 @@ From the perspective of accelerating queries and their
principles, Doris indexes
Among the above indexes, the prefix index and ZoneMap index are built-in
indexes automatically maintained by Doris, requiring no user management.
Inverted indexes, BloomFilter indexes, and NGram BloomFilter indexes need to be
manually created and managed by the user based on the scenario.
-| Type | Index | Accelerates Equal | Accelerates Not Equal |
Accelerates Range | Accelerates LIKE | Accelerates MATCH (Keywords, Phrases) |
Advantages | Limitations
|
+- Comparison of characteristics of different types of indexes
+
+| Type | Index | Advantages |
Limitations |
|------------|-------------------|-------------------|-----------------------|-------------------|------------------|----------------------------------------|-------------------------------------------|-------------------------------------------|
-| Point Query | Prefix Index | YES | YES
| YES | NO | NO
| Most commonly used filter condition | Only one prefix index per table
|
-| Point Query | Inverted Index | YES | YES
| YES | COMING | YES
| Supports tokenization and keyword matching, can build index on any column,
multi-condition combination | Large index storage space, similar to raw data |
-| Skip | ZoneMap Index | YES | YES
| YES | NO | NO
| Built-in index, small index storage space | Only one prefix index per table
|
-| Skip | BloomFilter Index | YES | NO
| NO | NO | NO
| More precise than ZoneMap, small index space | Supports few query types, only
supports equal, not others (not equal, range, LIKE, MATCH) |
-| Skip | NGram BloomFilter | NO | NO
| NO | YES | NO
| Supports LIKE acceleration, small index space | Only supports LIKE
acceleration |
+| Point Query | Prefix Index | Built-in index, best performance |
Only one prefix index per table |
+| Point Query | Inverted Index | Supports tokenization and keyword
matching, building index on any column, multi-condition combination and
accelerating more functions | Large index storage space, similar to raw data |
+| Skip | ZoneMap Index | Built-in index, small index storage space
| Only one prefix index per table |
+| Skip | BloomFilter Index | More precise than ZoneMap, medium index
space | Supports few query types, only supports equal, not others (not equal,
range, LIKE, MATCH) |
+| Skip | NGram BloomFilter | Supports LIKE acceleration, medium index
space | Supports few query types, only supports LIKE acceleration |
+
+- List of operators and functions for index acceleration
+
+| Operator or Function | Prefix Index | Inverted Index | ZoneMap Index |
BloomFilter Index | NGram BloomFilter Index |
+|-------------------------|---------|---------|--------------|-----------------|------------------------|
+| = | YES | YES | YES | YES
| NO |
+| != | YES | YES | NO | NO
| NO |
+| IN | YES | YES | YES | YES
| NO |
+| NOT IN | YES | YES | NO | NO
| NO |
+| >, >=, <, <=, BETWEEN | YES | YES | YES | NO
| NO |
+| IS NULL | YES | YES | YES | NO
| NO |
+| IS NOT NULL | YES | YES | NO | NO
| NO |
+| LIKE | NO | NO | NO | NO
| YES |
+| MATCH, MATCH_* | NO | YES | NO | NO
| NO |
## Index Design Guidelines
diff --git a/versioned_docs/version-2.1/table-design/index/index-overview.md
b/versioned_docs/version-2.1/table-design/index/index-overview.md
index ef27453a8f8..cb6c6b9efca 100644
--- a/versioned_docs/version-2.1/table-design/index/index-overview.md
+++ b/versioned_docs/version-2.1/table-design/index/index-overview.md
@@ -39,13 +39,32 @@ From the perspective of accelerating queries and their
principles, Doris indexes
Among the above indexes, the prefix index and ZoneMap index are built-in
indexes automatically maintained by Doris, requiring no user management.
Inverted indexes, BloomFilter indexes, and NGram BloomFilter indexes need to be
manually created and managed by the user based on the scenario.
-| Type | Index | Accelerates Equal | Accelerates Not Equal |
Accelerates Range | Accelerates LIKE | Accelerates MATCH (Keywords, Phrases) |
Advantages | Limitations
|
+- Comparison of characteristics of different types of indexes
+
+| Type | Index | Advantages |
Limitations |
|------------|-------------------|-------------------|-----------------------|-------------------|------------------|----------------------------------------|-------------------------------------------|-------------------------------------------|
-| Point Query | Prefix Index | YES | YES
| YES | NO | NO
| Most commonly used filter condition | Only one prefix index per table
|
-| Point Query | Inverted Index | YES | YES
| YES | COMING | YES
| Supports tokenization and keyword matching, can build index on any column,
multi-condition combination | Large index storage space, similar to raw data |
-| Skip | ZoneMap Index | YES | YES
| YES | NO | NO
| Built-in index, small index storage space | Only one prefix index per table
|
-| Skip | BloomFilter Index | YES | NO
| NO | NO | NO
| More precise than ZoneMap, small index space | Supports few query types, only
supports equal, not others (not equal, range, LIKE, MATCH) |
-| Skip | NGram BloomFilter | NO | NO
| NO | YES | NO
| Supports LIKE acceleration, small index space | Only supports LIKE
acceleration |
+| Point Query | Prefix Index | Built-in index, best performance |
Only one prefix index per table |
+| Point Query | Inverted Index | Supports tokenization and keyword
matching, building index on any column, multi-condition combination and
accelerating more functions | Large index storage space, similar to raw data |
+| Skip | ZoneMap Index | Built-in index, small index storage space
| Only one prefix index per table |
+| Skip | BloomFilter Index | More precise than ZoneMap, medium index
space | Supports few query types, only supports equal, not others (not equal,
range, LIKE, MATCH) |
+| Skip | NGram BloomFilter | Supports LIKE acceleration, medium index
space | Supports few query types, only supports LIKE acceleration |
+
+- List of operators and functions for index acceleration
+
+| Operator or Function | Prefix Index | Inverted Index | ZoneMap Index |
BloomFilter Index | NGram BloomFilter Index |
+|-------------------------|---------|---------|--------------|-----------------|------------------------|
+| = | YES | YES | YES | YES
| NO |
+| != | YES | YES | NO | NO
| NO |
+| IN | YES | YES | YES | YES
| NO |
+| NOT IN | YES | YES | NO | NO
| NO |
+| >, >=, <, <=, BETWEEN | YES | YES | YES | NO
| NO |
+| IS NULL | YES | YES | YES | NO
| NO |
+| IS NOT NULL | YES | YES | NO | NO
| NO |
+| LIKE | NO | NO | NO | NO
| YES |
+| MATCH, MATCH_* | NO | YES | NO | NO
| NO |
+| array_contains | NO | YES | NO | NO
| NO |
+| array_overlaps | NO | YES | NO | NO
| NO |
+| is_ip_address_in_range | NO | YES | NO | NO
| NO |
## Index Design Guidelines
diff --git a/versioned_docs/version-3.0/table-design/index/index-overview.md
b/versioned_docs/version-3.0/table-design/index/index-overview.md
index ef27453a8f8..cb6c6b9efca 100644
--- a/versioned_docs/version-3.0/table-design/index/index-overview.md
+++ b/versioned_docs/version-3.0/table-design/index/index-overview.md
@@ -39,13 +39,32 @@ From the perspective of accelerating queries and their
principles, Doris indexes
Among the above indexes, the prefix index and ZoneMap index are built-in
indexes automatically maintained by Doris, requiring no user management.
Inverted indexes, BloomFilter indexes, and NGram BloomFilter indexes need to be
manually created and managed by the user based on the scenario.
-| Type | Index | Accelerates Equal | Accelerates Not Equal |
Accelerates Range | Accelerates LIKE | Accelerates MATCH (Keywords, Phrases) |
Advantages | Limitations
|
+- Comparison of characteristics of different types of indexes
+
+| Type | Index | Advantages |
Limitations |
|------------|-------------------|-------------------|-----------------------|-------------------|------------------|----------------------------------------|-------------------------------------------|-------------------------------------------|
-| Point Query | Prefix Index | YES | YES
| YES | NO | NO
| Most commonly used filter condition | Only one prefix index per table
|
-| Point Query | Inverted Index | YES | YES
| YES | COMING | YES
| Supports tokenization and keyword matching, can build index on any column,
multi-condition combination | Large index storage space, similar to raw data |
-| Skip | ZoneMap Index | YES | YES
| YES | NO | NO
| Built-in index, small index storage space | Only one prefix index per table
|
-| Skip | BloomFilter Index | YES | NO
| NO | NO | NO
| More precise than ZoneMap, small index space | Supports few query types, only
supports equal, not others (not equal, range, LIKE, MATCH) |
-| Skip | NGram BloomFilter | NO | NO
| NO | YES | NO
| Supports LIKE acceleration, small index space | Only supports LIKE
acceleration |
+| Point Query | Prefix Index | Built-in index, best performance |
Only one prefix index per table |
+| Point Query | Inverted Index | Supports tokenization and keyword
matching, building index on any column, multi-condition combination and
accelerating more functions | Large index storage space, similar to raw data |
+| Skip | ZoneMap Index | Built-in index, small index storage space
| Only one prefix index per table |
+| Skip | BloomFilter Index | More precise than ZoneMap, medium index
space | Supports few query types, only supports equal, not others (not equal,
range, LIKE, MATCH) |
+| Skip | NGram BloomFilter | Supports LIKE acceleration, medium index
space | Supports few query types, only supports LIKE acceleration |
+
+- List of operators and functions for index acceleration
+
+| Operator or Function | Prefix Index | Inverted Index | ZoneMap Index |
BloomFilter Index | NGram BloomFilter Index |
+|-------------------------|---------|---------|--------------|-----------------|------------------------|
+| = | YES | YES | YES | YES
| NO |
+| != | YES | YES | NO | NO
| NO |
+| IN | YES | YES | YES | YES
| NO |
+| NOT IN | YES | YES | NO | NO
| NO |
+| >, >=, <, <=, BETWEEN | YES | YES | YES | NO
| NO |
+| IS NULL | YES | YES | YES | NO
| NO |
+| IS NOT NULL | YES | YES | NO | NO
| NO |
+| LIKE | NO | NO | NO | NO
| YES |
+| MATCH, MATCH_* | NO | YES | NO | NO
| NO |
+| array_contains | NO | YES | NO | NO
| NO |
+| array_overlaps | NO | YES | NO | NO
| NO |
+| is_ip_address_in_range | NO | YES | NO | NO
| NO |
## Index Design Guidelines
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
