Lyftron allows defining an index on a View if the underlying engine supports indexes. Managing indexes in Lyftron is available through GUI and SQL statements like CREATE / DROP INDEX.
Indexes in Lyftron are virtual, which means they have no representation in the underlying data store until a view is cached.
See Caching and partitioning for more details.
Currently, Lyftron supports creating indexes on views in virtual databases backed by:
- Microsoft SQL Server,
- ADO.NET (depends on the database),
- ODBC (depends on the database).
The screen for managing indexes can be found by clicking Databases -> database name -> view name -> Indexes
(note: the underlying provider must have Lyftron support for indexes, e.g., MS SQL Server)
You can define a new index by clicking the Add index button:
Type in the name of the index and pick at least one column.
Check Unique and Clustered check-boxes if required.
More columns can be added using the Add column button.
Clicking Save will redirect you to the index list with the newly created index in preview mode:
From here you can go back to edit mode by clicking Edit or remove the index using Delete.