We want to query the Case History table to count how many times the Case Status is changed from Status A to B and B to A.
We have around 10 million Case History records in production. Want to know if there is any index applied to History Table. If not, is it possible to create Custom Index? Can't find this information in documentation.
Any help is appreciated. Thanks.