set Storage options


Indexing is the only Storage option we'll apply to fields. When an index is created for a field, FileMaker continuously tracks the field's contents for all records and maintains a sorted list of those contents. Sorts and Finds performed on indexed fields are substantially faster than on non-indexed fields, especially when a database has many records.

On the Storage tab of the Options dialog box, set Indexing to All for the Description field.

By default, FileMaker automatically creates indexes for fields when they're needed. You'll note that indexing has already been set to Minimal for fields to which you've applied the Unique validation option, for example. To force an index to be maintained for a field, you can click the Minimal or All radio button.

Strictly speaking, since this database is unlikely to contain hundreds or thousands of records, we could safely ignore indexing. It's discussed here mainly so you'll have experience using the feature.




Creating a Database in FileMaker Pro 8. Visual QuickProject Guide
Creating a Database in FileMaker Pro 8: Visual QuickProject Guide
ISBN: 0321414837
EAN: 2147483647
Year: 2005
Pages: 115

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net