Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   Improving Individual Query Performance > Updating Statistics >

Using Update Statistics With Very Large Databases

If you have an extremely large database and tables and indexes are fragmented, you can run UPDATE STATISTICS statements in parallel. To accomplish this, you must run UPDATE STATISTICS LOW with the PDQ priority set to a value that is between 1 and 10. If the PDQ priority is set to 1, 10 percent of the index fragments are analyzed at one time for the current table. If PDQ is set to 5, 50 percent of the index fragments are analyzed at one time for the current table. If PDQ is set to 10, all fragments are analyzed at one time for the current table.

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]