What is difference (in this respect) between indexes created simply by setting field names in IndexFieldNames property and indexes created in "harder" way? Do they influence speed the same way or there is a difference?
Another question: Imagine you have to sequentially go through all records and determine whether records satisfy some criteria, if yes you update those records.
Is there any benefit in using filter before that, so that condition is set in filter? I mean, if filter does not utilize indexes, then it is just overhead, right?