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 Materialization 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 Querona provider has to support 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.