Indexes

Querona allows defining an index on a View if the underlying database engine supports indexes. Managing indexes in Querona is available through GUI and SQL statements like CREATE INDEX and DROP INDEX.

Indexes in Querona are virtual, which means they have no representation in the underlying data store until a view is cached.

Note

See Caching and partitioning for more details.

Currently, Querona supports creating indexes on views in virtual databases backed by:

  • Microsoft SQL Server,
  • ADO.NET (depends on the database),
  • ODBC (depends on the database).

Managing indexes

The screen for managing indexes can be found by navigating Databases ‣ *database name* ‣ *view name* ‣ Indexes.

Index management

Note

The underlying provider must have Querona support for indexes, e.g., MS SQL Server or Oracle.

You can define a new index by clicking the Add index button:

Index edit

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:

Index list

From here you can go back to edit mode by clicking Edit or remove the index using Delete.