In the fast case the 'Felhasználók%' part is known at query planning
time, so it can be a prefix search.
In the slow case, the planner doesn't know what that value will be, it
could be something that starts with '%' for example.
First of all, it CANNOT start with '%'. This is a fact and this fact can be determined by analyzing the query. Something that the query planner should do, right?Second argument: the same query is also slow with the ^@ operator...
Oh I see, the query planner does not know that there will be no % characters in file and folder names.
But what is the solution then? It just seems wrong that I can speed up a query 1000 times by replacing it with a nested loop in a pl/sql function :(
