Richard Huxton wrote:
Mike Adams wrote:
So.
The first query should pull all 'MOM' records that have one or more
corresponding, and possibly orphaned, unassigned receiving records
belonging to the same po_cd and item_cd.
The second query should pull all unassigned, and possibly orphaned
rece
Mike Adams wrote:
So.
The first query should pull all 'MOM' records that have one or more
corresponding, and possibly orphaned, unassigned receiving records
belonging to the same po_cd and item_cd.
The second query should pull all unassigned, and possibly orphaned
receiving records that have
Richard Huxton wrote:
(quoted OP lines edited for brevity...)
Mike Adams wrote:
...
I've reworked two
queries (as text attachment as they are wide lines) to enhance the
planner's chance of speeding up the queries (Oracle8i's).
Well, I can't say it's standard procedure to look at Oracle queri
Mike Adams wrote:
Hello! I'm a long time lurker who has become responsible for maintaining
/ updating utility queries at work. I've reworked two queries (as text
attachment as they are wide lines) to enhance the planner's chance of
speeding up the queries (Oracle8i's).
Well, I can't say it's
