whether an index is used or not depends on the context. of course, 4D can't use an index that does not exist, but otherwise, just because an index is defined it doesn't mean that it will be used.
the exact same query/sort condition may not alway use indexes, it depends on the current selection to all records ratio, whether an index update in progress, etc. that is why one can only say for sure by running the application for some time with realistic data and usage. see GET DATABASE MEASURES (14R3) http://kb.4d.com/assetid=77205 2017/09/14 16:53、Andrew Hobson via 4D_Tech <[email protected]<mailto:[email protected]>> のメール： Is this possible with 4D v13 or must I use an external tool ? ********************************************************************** 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] **********************************************************************
