Function-Based Indexes

An expression like WHERE LOWER(email) won't use an index created for the email column. By creating a function-based index (functional index) you can use this condition with full index support.