Indexes are not free. Each additional index will slightly increase the size of the Core Data storage, and also make it linger a bit to save objects. Thus, if an index for a given property will never be used, or if it is rarely used so that the performance bonus from its indexing is not significant, performance (and storage usage) will actually be best without an index.
source share