Is it possible to use a scratchpad in a SQL UDF? I have a partitioned
environment and therefore cannot have an external UDF that reads SQL.
My UDF needs to perform a lookup in a couple of tables. It needs to
be called in a query that will return millions of rows. Hitting the
database for row is very slow. Using a scratchpad to keep the first
database hit in memory would be the best option.