* [[topbar |Table of Contents]] * [[intro:overview:what|Introduction]] * [[install:home|Installation]] * [[install:editions|Product Editions]] * [[install:requirements|System Requirements]] * [[install:platforms|Supported Platforms]] * [[install:guides:home|Installation Guides]] * [[install:licensing:home|Licensing]] * [[install:releases:home|Release Notes]] * [[admin:home|Administration]] * [[admin:admin:home|Administration Basics]] * [[admin:admin:architecture:home|Omnidex Architecture]] * [[admin:admin:applications:home|Building Applications]] * [[admin:basics:home|Omnidex Fundamentals]] * [[admin:basics:environments:home|Omnidex Environments]] * [[admin:basics:sqlengine:home|Omnidex SQL Engine]] * [[admin:basics:updates:home|Omnidex Updates]] * [[admin:basics:network:home|Network Services]] * [[admin:indexing:home|Omnidex Indexing]] * [[admin:indexing:concepts:home|Indexing Concepts]] * [[admin:indexing:indexes:home|Indexing Options]] * [[admin:indexing:creation:home|Index Creation]] * [[admin:indexing:strategies:home|Indexing Strategies]] * [[admin:indexing:activecounts:home|ActiveCounts]] * [[admin:indexing:powersearch:home|PowerSearch]] * [[admin:indexing:autocomplete:home|AutoComplete]] * [[admin:indexing:text:home|Omnidex Text]] * [[admin:features:home|Omnidex Features]] * [[admin:features:snapshots:home|Omnidex Snapshots]] * [[admin:features:grids:home|Omnidex Grids]] * [[admin:features:rollups:home|Rollup Tables]] * [[admin:features:geo:home|Geographic Searches]] * [[admin:features:expressioncols:home|Expression Columns]] * [[admin:features:segments:home|Omnidex Segments]] * [[admin:features:attach:home|Attaching Data]] * [[admin:features:export:home|Exporting Data]] * [[admin:optimization:home|Optimizing Queries]] * [[admin:optimization:plans:home|Query Plans]] * [[admin:optimization:caches:home|Dynamic Caches]] * [[admin:optimization:config:home|Configuring Omnidex]] * [[integration:home|Integration]] * [[integration:rdbms:home|Relational Databases]] * [[integration:rdbms:oracle:home|Oracle]] * [[integration:rdbms:sqlserver:home|SQL Server]] * [[integration:rdbms:mysql:home|MySQL]] * [[integration:rdbms:odbc:home|Generic ODBC]] * [[integration:rawdata:home|Raw Data Files]] * [[integration:rawdata:fixed:home|Fixed-length Files]] * [[integration:rawdata:delimited:home|Delimited Files]] * [[integration:rawdata:ost:home|Standalone Tables]] * [[dev:home|Development]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:overview|Overview]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[dev:connections:home|Connection Strings]] * [[dev:odbc:home|ODBC Interface]] * [[dev:jdbc:home|JDBC Interface]] * [[dev:debugging:home|Logging/Debugging]] * [[programs:home|Programs]] * [[programs:odxsql:home|OdxSQL]] * [[programs:odxnet:home|OdxNet]] * [[appendix:home|Appendix]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[http://www.omnidex.com/download/|Downloads]] * [[support:home|Support]]

~~NOTOC~~ {{page>:top_add&nofooter&noeditbtn}} ====== Administration: Omnidex Indexing ====== ===== PowerSearch ===== [[admin:indexing:powersearch:home|Overview]] | [[admin:indexing:powersearch:example|Example]] | [[admin:indexing:powersearch:sql|SQL]] | [[admin:indexing:powersearch:optimization|Optimization]] | [[admin:indexing:powersearch:custom|Customization]] | **[[admin:indexing:powersearch:tips|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 "William, Bill, Billy, Will, Williams, Willie, Willis, Wilson". Because of this, administrators should expect that a PowerSearch may take more time than a regular search. This is generally not noticeable until the search terms have been expanded by at least ten times. * When creating your own [[admin:indexing:powersearch:custom|custom synonym lists]], it is generally recommended to restrain a search term to ten or less synonyms. This is not a requirement, and long synonym lists are allowed; however, adminstrators should expect an increase in search time as the synonym lists grow in size. * Most synonym lists allow one word to be expanded into multiple words, such as expanding a given name to include its common variations. There are other types of synonyms that can add flexibility to your searches. Here are some examples: * **Credit Scores** - Create synonyms of "EXCELLENT", "GOOD", "FAIR" and "POOR" to equate to ranges of credit codes, allowing a user to ask for those people with GOOD or EXCELLENT credit. * **Age Brackets** - Create synonyms of "BOOMER", "GENX", "GENY" and so on to represent age brackets, allowing a user to ask for those people who are Baby Boomers. * **Income Brackets** - Create synonyms such as "WEALTHY" and "MIDDLECLASS" to represent income brackets appropriate to a given industry. * **Education Brackets** - Create synonyms such as "UNDERGRADUATE" and "POSTGRADUATE" to represent education brackets. * Administrators should be cautious about using multiple options in the same $CONTAINS function as it can have a multiplicative effect on the number of search terms. For example, using SYNONYMS for a given name of "William" produces the search terms, "William, Bill, Billy, Will, Williams, Willie, Willis, Wilson". Using SYNONYMS and MISSPELLINGS combined produces the search terms of IN "William, Willian, Willia, Williams, Lilliam, Bill, Billi, Billy, Billye, Will, Willy, Willa, Williams, William, Willian, Willie, Willis, Wilson". This is because the MISSPELLINGS is applied to each of the synonyms. * Administrators should be cautious about the order of the options used in a $CONTAINS function. For example, using options of "SYNONYMS=list, MISSPELLINGS" tells Omnidex to expand the search terms based on the synonym list, and then to search for the misspellings for each of the synonyms. Using options of "MISSPELLINGS, SYNONYMS=list" tells Omnidex to search for the misspellings of each of the synonyms and then search for the synonyms of each misspelling. ===== ===== **[[admin:indexing:powersearch:custom|Prev]]** ====== Additional Resources ====== See also: {{page>:admin:indexing:see_also&nofooter&noeditbtn}} {{page>:bottom_add&nofooter&noeditbtn}}

Back to top
admin/indexing/powersearch/tips.txt ยท Last modified: 2016/06/28 22:38 (external edit)
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0