Skip to content

IndexesΒΆ

Since Epsio views are regular SQL tables that sit within your database, creating indexes on top of views is recommended and can highly improve the performance of queries. Indexes help the database to quickly locate and access the data without having to scan the entire Epsio view.

To create an index on a view, you can simply use the builtin syntax for view creation in your database:

CREATE INDEX index_name ON view_name (column_name, ...);