Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

当属性不存在时match语句执行优化 #5633

Closed
nebula-bots opened this issue Jul 12, 2023 · 0 comments · Fixed by #5634
Closed

当属性不存在时match语句执行优化 #5633

nebula-bots opened this issue Jul 12, 2023 · 0 comments · Fixed by #5634
Assignees
@Shylock-Hg
Labels
affects/v3.5 auto-sync source/customer type/enhancement Type: make the code neat or more efficient

Comments

@nebula-bots
Copy link
Contributor

nebula-bots commented Jul 12, 2023 •
edited by wey-gu
Loading

Introduction

当属性不存在时match语句选择一个索引全表扫描，数据量特别大时返回结果很慢
match (v:player) where v.player.name1=="Tim Duncan" return v(name1不存在)
image

image

Contents

尽量避免这种情况的全表扫描，可以立刻反回结果
Related work
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Shylock-Hg Shylock-Hg

Labels
affects/v3.5 auto-sync source/customer type/enhancement Type: make the code neat or more efficient
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Enhancement/eliminate invalid filter Shylock-Hg/nebula
2 participants
@Shylock-Hg @nebula-bots