> Le 20 mai 2017 à 01:24, Douglas von Roeder via 4D_Tech <[email protected]> > a écrit : > > Ronald: > > Distinct values is a good suggestion - it will be interesting to see what's > in some of the fields but not the others.
From the doc, DISTINCT VALUES uses the index when it exists. Deleting/fixing the index before DISTINCT VALUES could help to discriminate if the issue is ( field duplicates | index corruption ). -- Arnaud de Montard ********************************************************************** 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] **********************************************************************
