Is there any point in adding an index to a (non materialized) view? I'm using Postgres, but I guess the question applies to SQL in general.

CodePudding user response：

In general, non materialized views basically rely on their underlying queries both for the result set and with regard to performance. So, to index a view, you should simply look at indexing the underlying query contained within the view.