softDelete and database indexing

softDelete and database indexing

MGatner
@xxxx[{::::::::::::::::::::::::::::::::>
Posts: 619
Threads: 59
Joined: Dec 2016
Reputation: 45

08-21-2019, 11:23 AM

For the database gurus… CI4's `softDeletes` feature means that the `deleted_at` field will be a part of pretty much every read query for a model’s table. When creating indices, should I be indexing everything against `deleted_at` as well? Both directions?

Messages In This Thread

softDelete and database indexing - by MGatner - 08-21-2019, 11:23 AM

RE: softDelete and database indexing - by php_rocs - 08-21-2019, 02:03 PM

RE: softDelete and database indexing - by includebeer - 08-21-2019, 04:09 PM

RE: softDelete and database indexing - by php_rocs - 08-21-2019, 08:23 PM

RE: softDelete and database indexing - by includebeer - 08-22-2019, 08:08 AM

RE: softDelete and database indexing - by php_rocs - 08-22-2019, 12:38 PM

RE: softDelete and database indexing - by includebeer - 08-23-2019, 05:58 AM

RE: softDelete and database indexing - by kilishan - 08-22-2019, 09:31 PM

RE: softDelete and database indexing - by includebeer - 08-23-2019, 06:00 AM

RE: softDelete and database indexing - by dave friend - 08-23-2019, 07:55 AM

RE: softDelete and database indexing - by php_rocs - 08-23-2019, 08:29 AM

RE: softDelete and database indexing - by InsiteFX - 08-23-2019, 07:58 AM

RE: softDelete and database indexing - by dave friend - 08-23-2019, 08:01 AM

RE: softDelete and database indexing - by MGatner - 08-24-2019, 06:32 AM

RE: softDelete and database indexing - by dave friend - 08-24-2019, 06:25 PM

RE: softDelete and database indexing - by MGatner - 08-25-2019, 03:56 AM

RE: softDelete and database indexing - by dave friend - 08-25-2019, 11:25 AM

RE: softDelete and database indexing - by MGatner - 08-25-2019, 04:58 PM