Layout in a database system is performed using workload information.
Execution information for a workload is obtained. Cumulative access and
co-access information for database objects is then assembled. A cost
model is developed for quantitatively capturing the value of different
layouts, and a search is performed for a recommended database layout. In
one embodiment, a greedy search is performed which initially attempts
provide a layout that minimizes co-location of objects on storage
objects, and then attempts to improve that layout via a greedy search.