https://www.omnidex.com/docs/v54/ 2026-04-29T19:10:38+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:expressioncols:declaration&rev=1467153531&do=diff Administration: Omnidex Features Expression-based Columns Overview | Declaring Expression-based Columns | Optimizing Queries ---------- Declaring Expression-based Columns Expression-based columns are declared in the Environment File as though they were a normal column in a table. They must always be declared at the end of the column list, after all of the columns that do reside in the underlying database. Expression-based columns have names and datatypes just like normal columns, but they… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:features:expressioncols:home&rev=1467153531&do=diff Administration: Omnidex Features Expression-based Columns Overview | Declaring Expression-based Columns | Optimizing Queries ---------- Overview Most Omnidex environment by replicating all of the tables and columns in the underlying database. With relational databases, a partial subset of tables and columns can be declared, allowing for a smaller database that is easier to manage. At times, however, administrators may want to add additional columns that do not exist in the underlying data… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:features:expressioncols:optimization&rev=1467153531&do=diff Administration: Omnidex Features Expression-based Columns Overview | Declaring Expression-based Columns | Optimizing Queries ---------- Optimizing with Expression-based Columns Expression-based columns provide several opportunities for optimizing SQL statements. Expression-based columns can be used to classify data into more valuable formats. Expression-based columns are also the best way to index the result of expressions. In both of these cases, Omnidex will take advantage of indexes o…