Boosting Database Performance & Easing Maintenance Tasks with Partitioning in ASE 15

    By: Eric Miner on May 15, 2009

    An Executive Overview
    ASE 15’s Data Partitioning option is a powerful addition to your database maintenance and performance toolbox. It can greatly reduce the time it takes to complete regular maintenance tasks while eliminating some of them all together. With these tools, data availability is vastly improved and your life as a DBA becomes less complicated.

    ASE 15’s Data Partitioning option will also provide an overall performance boost. Queries will run against smaller ‘pieces’ of data and the optimizer and query processor know what data values are on an individual partition and will avoid reading any that don’t contain the required data.



     

     

    TwitterLLinkedinLFacebook

    Copyright © 2014 ISUG-TECH. All Rights Reserved
    All material, files, logos and trademarks within this site are copyright their respective organizations

    Terms of Service - Privacy Policy - Contact the Help Desk