Administration: Omnidex Indexing

Index Creation

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, each of which will sequentially scan the table and populate the index.

Omnidex's indexing strategy often results in hundreds of indexes per table; therefore, Omnidex takes a more optimized approach to index creation. It is inefficient to sequentially scan the table for each and every index, regardless of whether there will be a few indexes, or hundreds of indexes. With Omnidex, you first declare all of the properties and options for all of the indexes, and then populate all of the indexes with one command. This command scans the table just once, populating all of the indexes at the same time. This allows indexes to be created at a much faster rate than the relational databases.

If needed, Omnidex does allow an index to be created individually; however, this is not commonly needed. Omnidex generally populates indexes at a rate of 1-5 billion keywords per hour, depending on the underlying hardware. This fast indexing rate makes it convenient to simply rebuild all of the indexes, usually in minutes.

Additional Resources

See also:

 
Back to top
admin/indexing/creation/home.txt ยท Last modified: 2016/06/28 22:38 (external edit)