Summary


By following these aforementioned best practices, you should be able to write well-organized and logical code that performs well. Specifically, index and table creation were examined, where some options were discussed to squeeze additional performance out of them. Next, code maintenance was covered, where taking a little more time up front in the coding phase can save time and make your SQL procedures more manageable later. Finally, some performance best practices for SQL and SQL PL were shown.



    DB2 SQL PL. Deployment and Advanced Configuration Essential Guide for DB2 UDB on Linux., UNIX, Windows, i5. OS, z. OS
    Intelligent Enterprises of the 21st Century
    ISBN: N/A
    EAN: 2147483647
    Year: 2003
    Pages: 205

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net