https://www.omnidex.com/docs/v54/ 2026-05-02T02:49:23+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:text:advanced&rev=1467153531&do=diff Administration: Omnidex Indexing Omnidex Text Overview | Textual Datatypes | External Files | Proximity Searches | Advanced Searches | Displaying Results | Relevancy ---------- Advanced Searches When administrators speak of a complex query, they are usually referring to the complex Boolean and parenthetical relationships between pieces of criteria. By its very nature, an individual SQL criterion is not complex. Even if there are 20 pieces of criteria, each criteria is something like… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:text:clob&rev=1467153531&do=diff Administration: Omnidex Indexing Omnidex Text Overview | Textual Datatypes | External Files | Proximity Searches | Advanced Searches | Displaying Results | Relevancy ---------- Textual Datatypes Databases generally store text in character columns or in variable character columns (often called VARCHAR columns). These datatypes are good for storing smaller amounts of text, such as names, addresses and short descriptions. These datatypes are often limited in size, however. For larger amo… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:text:home&rev=1467153531&do=diff Administration: Omnidex Indexing Omnidex Text Overview | Textual Datatypes | External Files | Proximity Searches | Advanced Searches | Displaying Results | Relevancy ---------- Overview Omnidex allows applications to search for both textual and non-textual data using SQL statements. For most textual data, QuickText indexes parse the individual keywords in the column and allows them to be individually qualified. This feature is well suited for small textual fields, such as names, addr… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:text:proximity&rev=1467153531&do=diff Administration: Omnidex Indexing Omnidex Text Overview | Textual Datatypes | External Files | Proximity Searches | Advanced Searches | Displaying Results | Relevancy ---------- Proximity Searches FullText Indexes are a specialized index designed for large blocks of text, such as abstracts, articles, and text documents. FullText Indexes parse the contents of the column so that each word is indexed separately. FullText Indexes also track the position of each word in the field to aid in … text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:text:relevancy&rev=1467153531&do=diff Administration: Omnidex Indexing Omnidex Text Overview | Textual Datatypes | External Files | Proximity Searches | Advanced Searches | Displaying Results | Relevancy ---------- Relevancy When searching large blocks of text, relevancy becomes more important. If the criteria occurs many times in a large block of text, it can be considered more relevant than if the criteria occurs only once. When multiple words are nearer to each other, or occur nearer to the beginning of the block of … text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:text:results&rev=1467153531&do=diff Administration: Omnidex Indexing Omnidex Text Overview | Textual Datatypes | External Files | Proximity Searches | Advanced Searches | Displaying Results | Relevancy ---------- Displaying Results Proximity searches can qualify rows with large blocks of text using Phrase Searches, BEFORE Searches and NEAR Searches. Once the rows are qualified, the obvious next step is to display the results. This can be more difficult if the text is as long as an entire book, or some other large bloc… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:text:retrieve&rev=1467153531&do=diff Administration: Omnidex Indexing Omnidex Text Overview | Textual Datatypes | External Files | Proximity Searches | Advanced Searches | Displaying Results | Relevancy ---------- Retrieving External Files Omnidex allows a table to point to a collection of external text files. One of the columns in the table can contain the filename of an external text file. When the table is read, the text from the external file is retrieved and presented as a large text column in the table. In this …