Your fragmentation goals depend on the types of applications and the design of queries and transactions that access the table. For example, an ad hoc DSS application has different requirements from a Web OLTP application. Even applications of the same kind might have somewhat different requirements. You need to know both your data and your users.
To identify your fragmentation goals, consider the following issues as they apply to the applications that your users run on your database server.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]