I used to have this set as automatic and that did not help. According to KB 49932 you use Btree if the selectivity is near 1, and use cluster Btree if the selectivity is near 0. Where selectivity is calculated as selectivity = (number of distinct values in field) / (Total number of records in field) since the index is a UUID its selectivity would be 1 which would mean bTree is the ay to go. Now this article is dated July 2008 so But I would hope that the fundamental logic of the indexes would not have changed. -----------------------------------------------------------------------
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 11:54 PM, John DeSoi via 4D_Tech <[email protected]> > wrote: > > No, this is set as b-tree (automatic). I think that is best setting for this > field, but worth checking into to see if it might help. > > John DeSoi, Ph.D. > > >> On Jun 28, 2017, at 9: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] **********************************************************************
