Am 29.11.23 um 21:25 schrieb Dirschel, Steve:
I have a question on the execution time of a query and the fluctuations I'm seeing. I enabled auto_trace to capture some actual executions of a query by an app. Below are 2 executions of it. The top one took 1.697 milliseconds. The 2nd one took 31.241 milliseconds. Note the query has hints in it
what database are you using? PostgreSQL doesn't hav hints... Regards, Andreas -- Andreas Kretschmer - currently still (garden leave) Technical Account Manager (TAM) www.enterprisedb.com
