The field is indexed with btree since its designed for lots of unique values and its a UUID. This was based on the technote regarding the optimal index to use. -----------------------------------------------------------------------
MacCafe 4405 Talmadge St. Toledo, OH 43623 Eric Naujock - ACSA 10.2, 10.3, 10.4 Apple - ACTC 10.5, 10.6, 10.7, 10.8, 10.9, 10.10 http://www.mac-cafe.com email: e <mailto:[email protected]>[email protected] <mailto:[email protected]> AOL IM: erlic > On Jun 28, 2017, at 10:00 PM, Keisuke Miyako via 4D_Tech > <[email protected]> wrote: > > do you have cluster b-tree indexes for that field? > >> 2017/06/29 9:55、John DeSoi via 4D_Tech <[email protected]> のメール： >> >> 4D reports the table is not fragmented. I have not tried compacting or >> rebuilding indexes yet. You might give this a try to see if it makes a >> difference. > > > > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
