Let’s say I have a compound index involving these 3 columns. (name, email, phone) Is this index still will be used for these queries? The first query involves just 2 of indexed fields and the second …
Let’s say I have a compound index involving these 3 columns. (name, email, phone) Is this index still will be used for these queries? The first query involves just 2 of indexed fields and the second …