select a.* from (select * from ducc.job order by stateIndex asc, id
desc) a where id < 117000
Why is this query written like this, as opposed to, say:
select * from ducc.job order by stateIndex asc, id desc
where id < 117000
Do you get a different query plan / run time if you use a
On 06/01/2014 15:34, Rick Hillegas wrote:
Maybe your problem is that your methods are not public.
Damn it your right. That one method was not public!
Sorry :-(
Tim
Bryan Pendleton-3 wrote
>> Ostensibly the where clause really slow does the query. How come and how
>> do I remedy?
>
> Here's a good place to start:
>
> http://wiki.apache.org/db-derby/PerformanceDiagnosisTips
>
> thanks,
>
> bryan
>From ij show indexes:
DUCC|JOB
On 1/6/14 6:09 AM, Rick Hillegas wrote:
On 1/6/14 4:47 AM, Tim Dudgeon wrote:
I'm trying to write a function that performs aggregation and I'm not
clear on how to handle the varargs part.
Lets assume I was wanting to write a function that does averaging,
and handles null values correctly.
I'm
On 1/6/14 4:47 AM, Tim Dudgeon wrote:
I'm trying to write a function that performs aggregation and I'm not
clear on how to handle the varargs part.
Lets assume I was wanting to write a function that does averaging, and
handles null values correctly.
I'm defining my function like this:
CREATE F
I'm trying to write a function that performs aggregation and I'm not
clear on how to handle the varargs part.
Lets assume I was wanting to write a function that does averaging, and
handles null values correctly.
I'm defining my function like this:
CREATE FUNCTION MYAVG
( VALS DOUBLE ... )
RETUR