Re: Reminder about VFP compound indexes and best strategy

On 2017-11-03 20:21, Frank Cazabon wrote:

Individual indexes on each field should work, not an index on the compound expression.

The reason I was foggy on this is because I usually use a MariaDB backend and the index strategy is different there since it can't use two+ indexes. In the MariaDB case, an index on City,State (combined) would be best in that scenario, if I'm not mistaken.