Administración de PostgreSQL
Índices funcionales (cont.)

alvh=# CREATE INDEX sumas ON multi (suma(refsid, primarioid));
CREATE

alvh=# EXPLAIN SELECT * FROM multi WHERE suma(refsid, primarioid) BETWEEN 1 AND 10000;
NOTICE:  QUERY PLAN:

Index Scan using sumas on multi  (cost=0.00..227.82 rows=75 width=22)

EXPLAIN