@worldsendless Or move to another technology entirely like a data lake or data warehouse solution and transform the data on the way in, it's unlikely a 45 minute query is part of a transactional system i'd think?
Hi, I'm an science graduate and IT professional (Software, Cloud, Databases) and somewhat food (desserts) obsessed, One of the strings to my bow is being the technical support half of a desserts food blog (Keep calm and eat ice cream). Serial dabbler in wider STEM topics.