Content
View differences
Updated by Judith Roth 18 days ago
### Steps to reproduce
1. Search for a text
2. See that the search is slow
### What is the buggy behavior?
It always runs a sequential scan on `work_package_semantic_aliases`, which is quite slow (the bigger the table, the slower the search). The existing btree-index on `work_package_semantic_aliases.identifier` is not used (search is done with `lower` and `LIKE 'prefix%'`) search)
### What is the expected behavior?
It should use an index and be fast
###
### Screenshots and other files
See comments for `explain` output before / after
###
1. Search for a text
2. See that the search is slow
### What is the buggy behavior?
It always runs a sequential scan on `work_package_semantic_aliases`, which is quite slow (the bigger the table, the slower the search). The existing btree-index on `work_package_semantic_aliases.identifier` is not used (search is done with `lower` and `LIKE 'prefix%'`)
### What is the expected behavior?
It should use an index and be fast
###
### Screenshots and other files
See comments for `explain` output before / after
###