Hi Tim, Yes, it is smart enough to use a composite index. I think this started in v11, if I remember right. I think the index only kicks in if there are more than x number of records in the selection, though. Not sure what x is.
-- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236 <[email protected]> <www.synergyfarmsolutions.com> > On Jan 26, 2017, at 8:02 PM, Tim Nevels <[email protected]> wrote: > > Question: If I create a composite index for a table that contains 2 fields, > and you do an ORDER BY on the table using these 2 fields, does the 4D > database engine use this composite index and do a fast sort, or does it still > load all the records and do a sequential sort? ********************************************************************** 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] **********************************************************************
