Seems way off. Are the values unique or clustered around a few values? I'm seeing a few milliseconds to search 46 million records with a unique index value.
Have you tried DESCRIBE QUERY EXECUTION? John DeSoi, Ph.D. > On Aug 15, 2019, at 2:26 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > There are a lot of records in the table (about 1.3 million). > > Does this seem right? 70 seconds is a long time :) And why does it say it's > doing a *sequential* search? ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************