Function-Based & Invisible Indexes

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.