search

agdsn / hades

AG DSN Authentication and Authorization Infrastructure
MIT License
8 stars 3 forks source link

Create indexes on materialized views to improve lookup #10

Closed sebschrader closed 8 years ago

sebschrader commented 8 years ago

No indexes are currently created on the materialized views.

If unique indexes are used, the foreign server could return duplicate entries which would break the automatic refresh. We can either accept that or try to handle it somehow. Otherwise non-unique indexes could be used.