|Subject||Re: [ib-support] Adding index does nothing to select disctinct|
> Some of my reports take a minute or more. This query was just to load a list ofI have some queries that are quite complex, and doing them
> available job numbers.
in one 'hit' takes far too long, so I split and build a
master/detail which makes the report generation a lot
IF the query is just a list of available job numbers, then
DISTINCT should not come into it. On my system, each job has
a status, all jobs are in the table ( 250,000 now ) and as
jobs are added they start at status 1, selecting a batch
that have yet to be processed is just a matter of filtering
on status X - very fast report/grid.
L.S.Caine Electronic Services