ASE126 Opening Your Maintenance Window.pptVIP

ASE126 Opening Your Maintenance Window Making Update Statistics Run Faster From tuning the server to using a new feature We’ll talk about ASE ’s new feature ‘Sampling for Update Statistics” We’ll show you some simple things you can do now to help speed up update statistics All of these are designed to help make your statistics maintenance easier and more efficient Shrinking Maintenance Windows As datasets have grown so has the time it takes to run update statistics In some cases the maintenance window simply isn’t big enough to run update statistics whether it’s needed or not Your statistics