Oracle Speed Issue

From: Michael Azocar <mmazocar_at_flash.net>
Date: Tue, 11 May 1999 01:17:50 GMT
Message-ID: <2zLZ2.744$A7.1356@news.flash.net>

Hi,

I am having trouble with Oracle. I have this query...

SELECT DISTINCT INTERNAL_QUOTE_NUM, cust_name, proj_name, quote.time_stamp, STATUS FROM quote, quote_supp, supplier

WHERE quote_supp.quote = quote.quote_id AND quote_supp.WEB = 1 AND quote_supp.supplier='xxx' AND (quote.Locked_Flag = 0 or quote.Locked_Flag is Null) AND quote.status = 'In Process'

ORDER BY QUOTE.TIME_STAMP DESC When I run this query in house, it runs fine. (it is inside the firewall) When I run it at the client site, it still runs, but it takes a minute and a half to return! (outside their firewall) I tested this using SQL+ from a client inside their firewall and got the same results. To me this is pointing to either a network issue or a database optimization issue. The server is NT Terminal Server running Oracle 8. Where should I look next to get this speed issue fixed? Is my query the problem?

Thanks In advance.
--
Michael Azocar
Austin, Texas Received on Mon May 10 1999 - 20:17:50 CDT