Whatabout queries which only end with a wildcard? is there any way to
accelerate such a query?
> > Is there a way to make queries using the 'like' operator quicker, more
> > specifically for queries that look like:
> > select name from table where name like '%abc%';
>
> These kinds of queries (where the search string starts with a wildcard)
> never use indexes, so you're stuck with the sequential scan. A faster
> computer is probably your best option. :(