Re: Choosing Indices
You could try and fool the optimiser by making the select on the unwanted index fuzzier e/g/ SELECT where attribute MATCHES "*value" instead of SELECT where attribute = "value" - this has been very successful for us on 5.00.
You could try and fool the optimiser by making the select on the unwanted index fuzzier e/g/ SELECT where attribute MATCHES "*value" instead of SELECT where attribute = "value" - this has been very successful for us on 5.00.