Hi,
You could do the following prepared statement :
SELECT * FROM TABLE(ID NUMBER=?)
then you can set the parameter with a setObject(1,new Object[]
{1,2,3,4,5,6,7,8,9,10})
If you really want to do an external java function (though I do not
understand why), I suppose you could write
SELECT * FROM
Hi Thomas,
Thanks for the answer (I didnt see it at first).
I'm just testing every possible query plans for a study and I have
also an accumulated buffer that can do the trick as well.
Any thoughts on why the group sorted has a poorer performance? Is
there a way to override the choices?
Thanks
Hi,
I'm currently experimenting performance issues with the aggregate operation.
Here is my data : A historic of values for different ids
CREATE TABLE Bench (id INT NOT NULL, value INT NOT NULL, T TIMESTAMP NOT
NULL)
Thereafter I insert a lot of data in it (generated). My parameter for
Hey,
Ok, I'm gonna try to find a work around in order to rewrite the sql query.
Thanks anyway !
LP
Le 6 févr. 2012 à 08:41, Thomas Mueller thomas.tom.muel...@gmail.com a écrit :
Hi,
I'm afraid it would be quite hard to implement this optimization. Currently I
wouldn't know to do it I'm
Hi everyone,
I tried to evaluate the following SQL expression : SELECT a, AVG(b)
FROM (SELECT a,b FROM Table) GROUP BY a. I know it is a bit silly as
the expression is clearly (for a human) equivalent to SELECT a, AVG(b)
FROM Table GROUP BY a. Unfortunately, the sql is generated from a
program