archtechx/laravel-tips
1
0
Fork 0
mirror of https://github.com/archtechx/laravel-tips.git synced 2025-12-12 13:24:03 +00:00
Code Activity
laravel-tips/content/tips/you-can-create-a-special-index-for-a-transformation-of-a-column.md
lukinovec 32bb902024 Week 35/2022
2022-12-01 12:01:29 +01:00

651 B
Raw Permalink Blame History

title tweet_id thread_slug author_username images created_at slug
You can create a special index for a transformation of a column 1596508360001482753 weekly-thread-2022-35 tobias_petry
https://pbs.twimg.com/media/FdvFZNTXwAAwzV6.jpg
2022-11-26T14:17:09+00:00 you-can-create-a-special-index-for-a-transformation-of-a-column

⚡️ Database Tip

Most developers are puzzled that indexes are not used for e.g. WHERE LOWER(email) = ?. But contrary to common belief, an index can be created for these cases! It's called a function-based index and is supported by MySQL and PostgreSQL.

https://sqlfordevs.com/function-based-index