I have a query that runs slow for the first execution that gets substantially faster for subsequent executions, i.e. without any modifications. The hardware is abundant and the I/O is very low. My theory is that the problem might be rooted with compilation. First, is that a valid theory? Second, how can one improve compilation, generally? I have no other details. So please just provide whatever you can.
Thanks so much!