Advanced Index Types
Function-Based Index
CREATE INDEX upper_name_idx ON employees(UPPER(last_name));Helps queries using expressions.
Invisible Index
CREATE INDEX temp_idx ON employees(salary) INVISIBLE;Invisible indexes are ignored by the optimizer unless explicitly enabled.