Add a configuration setting when connecting a database (postgresql) with JMP in the same CustomSQL() instruction
Hi,I would like to speed up some SQL queries with special configuration values for my postgresql database.For example: SET random_page_cost = 1 How can I do this in JMP?Indeed if I create a CustomSQL querySET random_page_cost = 1Then a another one with a classic SELECT FROM... it doesn't work because the value "random_page_cost" seems to be reset to its default value on the second database connect...
jeff_kiesner
ron_horne