I’ve seen the same thing happen after changing/upgrading/migrating. There’s no one right answer as far as I know, but sometimes adding an extra index or two can tip the balance back in your favour with BAQs if you’re joining on non-standard keys.
I’ve seen the same thing happen after changing/upgrading/migrating. There’s no one right answer as far as I know, but sometimes adding an extra index or two can tip the balance back in your favour with BAQs if you’re joining on non-standard keys.