CREATE INDEXcreates indexes and
DROP INDEXremoves indexes.
Db.SQL, where query string contains an index declaration and has the form
CREATE [UNIQUE] INDEX indexName ON typeName (propertyName [ASC/DESC], ...).
indexNamemust be unique. If you define the same name more than once you will get an exception. It is possible to check if an index was already created by issuing a query, which selects a record from table
Nameequivalent to the index name as in the example below.
DROP INDEX index_name ON table_name. For example:
LegalEntityand a query is submitted for
Company, then if the query optimizer chooses to use the index, it will add a filter predicate, which checks that all objects from the index are instances of