[Store]  [Cart]  [Resources]  [Learning]  [About]  [Solutions]  [Consulting]  [News]  [Links]

Questions s Coffee cups indicate the complexity of a file, tip or article. One coffee cup is the easiest and three is the most advanced. To download a file, click on the green arrow icon next to the listing. If there are no coffee cups or platform icons, the listing may be an article, Quick Tip, Knowledgebase or bonus file.

Displaying 1...1 of 1 Resources found  [Another find]
Indexing    Intermediate   Quick Tip    Version 11
How Indexing Works on a Text Field
databasepros.com/list.php?resource_id=DBPros001127
FileMaker Pro indexes every word in a text field so that finds can be performed quickly. Think of the analogy of a book. Rather than trying to locate something by thumbing through each page, you look in the index and find all the pages numbers at once. FileMaker works in the same way. In order to make finds as fast as possible, the first 100 characters of every word is indexed. If you click into a field and type Command-I (Macintosh) or Ctrl-I (Windows), you can view the index of a field. Most characters are indexed but you may be surprised what characters designate a new word other than a space. The index does take up space, so if a field is not going to be searched on or used as a match field in a relationship, set the Storage Options in Manage Database to never index that field.


Philosophy of FileMaker Blog