4
Searching Text in SQL Server (#217)
source link: https://www.youtube.com/watch?v=4su7dW8603Q
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Searching Text in SQL Server (#217)
95 views
Jul 20, 2021
When you have a lot of data in your SQL database, searching for substrings in a column can be slow. Don't worry, Simon has some terrible awful, no good hacks that will get those queries running as fast as possible.
Show lessShow more
4 Comments
Sort by
Add a public comment...
Make the dame exercise with a million records and long strings,
A more efficient way of your hack would be to use a calculated column with the expression REVERSE(hangtag) and create the index on that. Then you would not need the additional table storage, except for the index, and there is no need for the trigger you mentioned.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK