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
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).
I'm looking for someone to eyeball them a
