5 Replies Latest reply on Feb 24, 2016 1:53 AM by sudha

    Indexing option usage

    sudha

      Hi all,

       

      Could you please tell me the use of Indexing option enabled for a field in Filemaker ?

       

      I have attached the screenshot for reference.

       

      Thank you.

       

      Capture.PNG

        • 1. Re: Indexing option usage
          Mike_Mitchell

          That option causes FileMaker to create indexes for that field if they're needed. For example, if someone does a Find that includes that field, an index will be created. If it's used for a value list or for a relationship, then a different index is created.

           

          If you turn this option off, it will prevent FileMaker from building an index for the field, which will require any search to be done unindexed (which will slow it down), and the field won't be available for value lists or for the target of a relationship.

          • 2. Re: Indexing option usage
            siplus

            Indexes come at a price, so don't index all indexable fields just because you can. Leave indexing on "none" with "automatically create" turned on.

            • 3. Re: Indexing option usage
              Mike_Mitchell

              Indeed. In fact, there are use cases where you should turn it off completely. For example, if you have a table that sees frequent turnover (say, a library table imported from an external source), turn on only the indexes you actually need. The import process will run much faster (since indexes have to be updated during the operation).

              • 4. Re: Indexing option usage
                siplus

                As Mike says, and also pay attention to QuickFind.

                 

                If you allow it, the very moment any user of your Database uses it it will happen: all indexable fields that exist on the layout QuickFind has been invoked on will become indexed.

                • 5. Re: Indexing option usage
                  sudha

                  Thank you all ! The information is helpful