Re: Running plain SQL statements???

From: Reid Lai <reidlai_at_hk.super.net>
Date: Sat, 13 Feb 1999 11:46:54 +0800
Message-ID: <36C4F5AE.1BA1F7B1@hk.super.net>

Sure. You can write a stored procedure for your SQL Statement. But does this get a better performance? I saw that there are many delete and insert statement with subquery. Most of your statements seems to be run at server side. Have you tuned up your subquery? I think you should consider your subquery first by using index and pay more attention on memory and disk I/O contention. What's your DBA comment?

--
Best Regards,

Reid Lai <reidlai_at_hk.super.net>
Oracle 7.3 Certified Database Administrator (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Feb 12 1999 - 21:46:54 CST