Functional index in database
Matam Kirankumar
![Matam Kirankumar]()
Matam Kirankumar
Engineering Manager at HashedIn by Deloitte with expertise in Cloud Computing
?? Database Tip
Most developers are puzzled that indexes are not used for e.g. WHERE LOWER(email) = ?
Most developers are unaware of it, but you CAN create an index so this will be very fast!!! It's called a functional index and is supported by MySQL and PostgreSQL.
For more database indexes tips read my medium blog
https://medium.com/@matam-kirankumar/indexes-in-postgresql-53f453e31729
references : https://sqlfordevs.com/concurrent-updates-locking