https://www.omnidex.com/docs/v54/ 2026-08-03T16:52:17+0000 https://www.omnidex.com/docs/v54/ https://www.omnidex.com/docs/v54/lib/tpl/simple/images/favicon.ico text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:creation:declaring&rev=1467153531&do=diff Administration: Omnidex Indexing Index Creation Overview | Declaring Indexes | Updating Indexes | Index Files | Performance ---------- Declaring Indexes The easiest way to add Omnidex indexes to a table is to append indexing information at the end of each column in the CREATE TABLE statement. This will suffice for most basic installations of Omnidex. The example below shows adding indexes to a table. Some columns have text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:creation:files&rev=1467153531&do=diff Administration: Omnidex Indexing Index Creation Overview | Declaring Indexes | Updating Indexes | Index Files | Performance ---------- Index Files Omnidex stores its indexes in files that are located in the Index Directory, which is specified in the CREATE DATABASE statement. The index files will all begin with the name of the database as declared in the CREATE DATABASE statement and will be followed by various names or numbers. Small databases will have only a handful of index files, wh… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:creation:home&rev=1467153531&do=diff Administration: Omnidex Indexing Index Creation Overview | Declaring Indexes | Updating Indexes | Index Files | Performance ---------- Overview Most relational databases, such as Oracle, SQL Server and MySQL, encourage administrators to create a few carefully-chosen indexes on a table. These indexes are created using the CREATE INDEX statement, which sequentially scans the table and populates the index. A table with three or four indexes will require three or four CREATE INDEX statements… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:creation:performance&rev=1467153531&do=diff Administration: Omnidex Indexing Index Creation Overview | Declaring Indexes | Updating Indexes | Index Files | Performance ---------- Performance Omnidex puts on premium on performance. Applications often use hundreds of Omnidex indexes, so it is important that all of these indexes can be built quickly. Omnidex also puts a premium on index size. Omnidex uses compression algorithms to make the indexes as small as possible while still allowing fast access. This allows the index to be qu… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:creation:updating&rev=1467153531&do=diff Administration: Omnidex Indexing Index Creation Overview | Declaring Indexes | Updating Indexes | Index Files | Performance ---------- Updating Indexes When Omnidex indexing is added to an Omnidex Environment, only the metadata about each index is added to the environment. The indexes themselves are not populated until an UPDATE INDEXES statement is issued. This is of great benefit since it allows multiple indexes to be built with one scan of the table. Omnidex applications frequently …