<< Click to Display Table of Contents >> Navigation: Concordance > Using Concordance > Searching > Advanced Searching |
Full-text and relational searches each have different pros and cons. It is important to understand when to use each. You can combine full-text and relational searches together - allowing you to search free-text paragraph fields and fixed fields at the same time to maximize your query potential.
Full-Text |
Relational |
---|---|
Searches the dictionary, uses index to display words from dictionary search |
Searches the database in real time |
Very fast |
Slower (depending on size of database) |
Hit highlighting in red |
No hit highlighting |
Can only search indexed fields |
Can search any field, indexed or not |
Easy to search multiple fields at once |
Searches one field at a time (unless fields groups are established in the .INI file) |
Used more often to find words |
Used more often to find dates, numbers, ranges, comparisons |
Cannot be used on date fields |
Can find specific dates or a range of dates within limits or outside limits |
Often used on paragraph fields |
Normally used on paragraph fields only to find empty/not empty fields |
Cannot be used until the database has been indexed. Will not find new data until database has been reindexed. |
Can be used whether or not the database has been indexed |
Cannot be used to find stopwords, since they are not in the dictionary |
Can be used to find stopwords |
Uses the * wildcard character. Can be used before or after the word. |
Uses the * wildcard character only at the end of a word. Use the ? wildcard character, to replace a single character in the middle of a word and in data searches. |
Always searches the complete contents of paragraph fields |
Only searches the complete contents of paragraph fields when using CO and NC operators |