From: Mike Whaley <MWhaley_at_PacBell.Net>
Date: 1996/12/16 Message-ID: <32B62277.5086@PacBell.Net>#1/1
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.
