Just make sure you test for your scale and with representative data and queries. There will be various tipping points with any technology. But you can find them with experimentation.