Re: sql performance question

cuz there's not as much data being requested.

You could get even more speed if you remove the where clause and put it in
the JOIN...

ON ODORD# = OLORD#
AND ODLINE = OLLINE
AND OLSTTS <> ODSTTS



Michael Schutte
Admin Professional
Bob Evans Farms, Inc.



midrange-l-bounces@xxxxxxxxxxxx wrote on 03/18/2008 03:22:11 PM:

Why would the last of the following two SQL statements run ten times
slower than the other?


SELECT *
FROM BLORDLP A
JOIN BLORDDP B
ON ODORD# = OLORD#
AND ODLINE = OLLINE
WHERE OLSTTS <> ODSTTS


SELECT ODORD#, ODLINE, ODSTTS, OLSTTS
FROM BLORDLP A
JOIN BLORDDP B
ON ODORD# = OLORD#
AND ODLINE = OLLINE
WHERE OLSTTS <> ODSTTS

The only difference being the first selects all fields and runs
immediately, the second only selects 4 fields and takes forever to
run.

thanks,

rick
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.