https://www.omnidex.com/docs/v54/ 2026-04-29T18:19:32+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:features:rollups:create&rev=1467153531&do=diff Administration: Omnidex Features Rollup Tables Overview | Design | Creation | Indexing | Optimization ---------- Creating Rollup Tables A rollup table is quite easy to create. The rollup tables are first created in the Omnidex Environment File, complete with the SQL statement that represents the rollup data. Then the UPDATE ROLLUPS statement is issued in ODXSQL to populate the rollup tables. Here is a simple example of declaring a regular table, followed by the creation of two rollup tab… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:features:rollups:design&rev=1467153531&do=diff Administration: Omnidex Features Rollup Tables Overview | Design | Creation | Indexing | Optimization ---------- Designing Rollup Tables Rollup tables are a good tool for improving performance, but they are not always the best or only solution. The Omnidex Administrator must consider the advantages and disadvantages of using rollup tables and determine when it is best to use them. This is the same as with most performance options, including partitioning and indexing. The table below lis… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:features:rollups:home&rev=1467153531&do=diff Administration: Omnidex Features Rollup Tables Overview | Design | Creation | Indexing | Optimization ---------- Overview When working with very large databases, there are lots of different techniques that can be used to improve performance. Omnidex provides a variety of partitioning strategies that can be used to quickly reduce a large database to a small result set. Omnidex provides specialized bitmap indexes geared for large databases. A variety of other techniques, from multi-column… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:features:rollups:indexing&rev=1467153531&do=diff Administration: Omnidex Features Rollup Tables Overview | Design | Creation | Indexing | Optimization ---------- Indexing Rollup Tables Once the rollup tables have been created and declared, they may be indexed using Omnidex indexing. There are no restrictions on indexing of rollup tables, and rollup tables can be indexed just like any other table. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:features:rollups:optimization&rev=1467153531&do=diff Administration: Omnidex Features Rollup Tables Overview | Design | Creation | Indexing | Optimization ---------- Optimizing Queries using Rollup Tables Omnidex will directly use Rollup Tables to optimize queries. This means that the queries themselves do not need to be changed. When rollup tables are declared, their relationship to the underlying data is understood. This allows Omnidex to look at queries against the underlying data and seamlessly query the rollup table. This design allo…