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 > <4d_tech@lists.4d.com> wrote: > > do you have cluster b-tree indexes for that field? > >> 2017/06/29 9:55、John DeSoi via 4D_Tech <4d_tech@lists.4d.com> のメール: >> >> 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:4d_tech-unsubscr...@lists.4d.com **********************************************************************