Planning a Fragmentation Strategy

Consider questions such as the following:

• What tables do queries and transactions access most often?
• What tables do queries and transactions join most often?
• What columns and operations are used in SELECT or WHERE clauses?
• For updates, what fields are changed most often?
• How are rows added to or deleted from tables?

The following sections describe the process of analyzing your data and applications to determine appropriate fragmentation schemes and fragment locations.