Subject complex indexes vs index key fields From Gaetano De Luisi <gaetanodd@hotmail.com> Date Fri, 24 Jul 2020 16:59:02 -0400 Newsgroups dbase.getting-started My DBF file has the potential of getting quyite large and to reduce the processing time for queries i need a couple of complex indexes. While creating the indexes, I noticed that saving the files took a fair amount of time for my test data of 25,000 records and appending the CSV data into the DBF also took noticeably longer than without the complex indexes. For large tables, what do you think would optimize performance: use a complex index (e.g. ["SO2"+left("0000000"+siteID,13)+DTOS(eTimeStamp)], or create a calculated field in the DBF file to create a simple index on? The database could potentially have daily uploads or deletions of data and exceed 1 million records.