Commercial database management systems support many physical design alternatives such as indexes, materialized views, and several different ways of horizontal partitioning of data or indexing structures viz. indexes and materialized views. Indexes and materialized views have been traditionally considered as crucial physical design alternatives that impact performance. Horizontal range partitioning, on the other hand, is used extensively by database administrators (DBAs) to have database physical designs that are easier to manage. For example, operations such as backup and restore, addition of new data and removal of old data can become much easier if data is partitioned and indexes are partitioned similarly with the underlying base tables.