Pathologically Eclectic Rubbish Lister | |
PerlMonks |
Re^2: Perl DBI query of MS SQL with LIKEby Bod (Parson) |
on May 30, 2023 at 17:24 UTC ( [id://11152528]=note: print w/replies, xml ) | Need Help?? |
Using LIKE with only a trailing % is usually slower than using SUBSTR I cannot speak for SQL Server but with MariaDB LIKE is optimised to use indexes as long as the first character is not a wildcard - '%' or '_'
In Section
Seekers of Perl Wisdom
|
|