I think we can handle manual index selection controls independently of the larger problem of query optimization.
Once I have time to get to know CEP-39 and the DS approach a little better, I can open another thread here to start talking about those in the context of the problems we need to solve.