Add additional indexes to Commerce Order table

I think we want to add indexes lightly... I seem to recall creating issues for sites in the past with large numbers of entities when we added an index. I think we need to do a bit of review that gives us an idea for how expensive this operation is, because it may need to be an opt-in for existing sites instead of an automatic update.

Maybe this would be easier to get in with some profiling results before and after on each of the index in a common scenario for each?

Likely a good idea to be selective about which fields to index. Order type looks particularity case specific.

+1

Recently, I needed to pull some orders for sending abandoned cart emails, and wanted to check the `created` column, which does not have an index.

The 4 year old patch to commerce_order.install does not apply to the latest commerce 7.x-1.x-dev and needs a reroll.

fixed names

Tested. Patch from comment #8 works as expected.

Thanks! Rerolled this to increment the update hook number to 7113 and add a settings based override to disable adding the indexes via the update function. With millions of rows, this could be quite a costly update. 😬

Committed!