When you create a partitioned table, you should create an index on the table. The index may be partitioned according to the same range values used to partition the table. In the following listing, the CREATE INDEX command for the BOOKSHELF_LIST_PART (list-partitioned) table is shown. The index partitions are placed in the PART1_NDX_TS and PART2_NDX_TS […]
Read More
Two significant enhancements to partitioning introduced in Oracle 11g are reference partitioning and interval partitioning. Reference partitioning allows you to create a partition based on a column that is not in the table being partitioned, but rather is a foreign key reference to a different table. This can be useful for partitioning related tables in […]
Read More
As user communities require more and more detailed information to remain competitive, it has fallen to database designers and administrators to help ensure that the information is managed effectively and can be retrieved for analysis efficiently. In this section, we discuss partitioning data and the reasons why it is so important when working with large […]
Read More
Learn how to check query performance to see if partitioned tables have made SQL Server faster.
Read More
Learn more about why and how to use partitioned tables in SQL Server to improve performance.
Read More
Oracle 11g interval partitioning extends the functionality of range partitioning so you can define equal-sized (future) partitions using an interval definition.
Read More
Partitioning can increase performance related to large tables in Oracle. Learn how by considering several examples.
Read More
Oracle 11g REF partitioning enables partitioning a table based on the foreign key parent-child relationship; in this case, the partitioning key of the child table is inherited from the parent table.
Read More
SQL Server partitioning can positively affect your environment and processes; this article can help you ensure that every process benefits from it.
Read More