https://www.omnidex.com/docs/v54/ 2026-08-03T12:35:06+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:powersearch:custom&rev=1467153531&do=diff Administration: Omnidex Indexing PowerSearch Overview | Example | SQL | Optimization | Customization | Tips ---------- Custom Usages Usages are essential to the customization of PowerSearch. The POWERSEARCH option instructs Omnidex to evaluate the columns referenced in the WHERE clause of the SELECT statement, and matches their USAGE clauses with the preconfigured instructions for each USAGE. These instructions describe actions such as using synonyms, checking for misspelling, or even doi… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:powersearch:example&rev=1467153531&do=diff Administration: Omnidex Indexing PowerSearch Overview | Example | SQL | Optimization | Customization | Tips ---------- Example In this example of PowerSearch, a user is trying to find a person in the database. They searched the database with many incorrect pieces of information, but still found who they were looking for. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:powersearch:home&rev=1467153531&do=diff Administration: Omnidex Indexing PowerSearch Overview | Example | SQL | Optimization | Customization | Tips ---------- Overview People do not think like databases. Databases are highly structured, and they follow rigid rules. People simply ask questions that they want answered, and they don't always follow the rules when they ask their questions. Databases record their data very precisely, and they expect queries to be precise as well. People do not always ask precise questions. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:powersearch:optimization&rev=1467153531&do=diff Administration: Omnidex Indexing PowerSearch Overview | Example | SQL | Optimization | Customization | Tips ---------- The Optimization Behind PowerSearch Generally there is no additional optimization needed for PowerSearch. PowerSearch generally consists of increasing the number of search terms used in a query. For example, a query that would search for a given name of 'William' can be expanded to include text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:powersearch:sql&rev=1467153531&do=diff Administration: Omnidex Indexing PowerSearch Overview | Example | SQL | Optimization | Customization | Tips ---------- The SQL Behind PowerSearch The POWERSEARCH Option In most scenarios, the key to implementing PowerSearch is to simply use the POWERSEARCH option on a SELECT statement. Alternatively, the SET POWERSEARCH ON command can be used to automatically activate PowerSearch for all queries on that connection. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:powersearch:tips&rev=1467153531&do=diff Administration: Omnidex Indexing PowerSearch Overview | Example | SQL | Optimization | Customization | Tips ---------- Implementation Tips The following tips are helpful when implementing PowerSearch in applications: * PowerSearch provides a more thorough search of the data, usually by increasing the number of search terms being used. For example, a query that would search for a given name of 'William' can be expanded to include