This last guys has some good suggestions. I would add the following:
- Remember to do an "ANALYZE" on each table and index. There is a
stored procedure shipped with Oracle for this. The COST based optimizer
does not stand a chance without it.
- Avoid ORDER BY in powerbuilder. Pull back the data to the client and
let that big pentium processor do the sorting. This is for datawindows
of course.
Received on Mon Dec 16 1996 - 00:00:00 CST