(08-21-2019, 04:09 PM)includebeer Wrote: (08-21-2019, 02:03 PM)php_rocs Wrote: @MGatner,
There is no need to index that field. It's only purpose is to exclude the deleted records from queries that should only show non deleted records.
If it’s used in every request then it could be a good idea to index it. But it I think it will only improve performance if you have a lot of record. For a small table, it won’t make a difference.
I disagree because there is no gains in indexing speed (regardless of the database size). This is assuming that the field is boolean. Sometimes you can over index.
