Overview of Attribute-Clustered Tables

An attribute-clustered table is a heap-organized table that stores data in close proximity on disk based on user-specified clustering directives. The directives specify columns in single or multiple tables.

school management

The directives are as follows:

• The CLUSTERING ... BY LINEAR ORDER directive orders data in a table according to specified columns.Consider using BY LINEAR ORDER clustering, which is the default, when queries qualify the prefix of columns specified in the clustering clause. For example, if queries of sh.sales often specify either a customer ID or both customer ID and product ID, then you could cluster data in the table using the linear column order cust_id, prod_id.
  software development
• The CLUSTERING ... BY INTERLEAVED ORDER directive orders data in one or more tables using a special algorithm, similar to a Z-order function, that permits multicolumn I/O reduction.Consider using BY INTERLEAVED ORDER clustering when queries specify a variety of column combinations. For example, if queries of sh.sales specify different dimensions in different orders, then you can cluster data in the sales table according to columns in these dimensions.
  staff augmentation service

Attribute clustering is only available for direct path INSERT operations. It is ignored for conventional DML.

This section contains the following topics:

• Advantages of Attribute-Clustered Tables
• Join Attribute Clustered Tables
• I/O Reduction Using Zones
• Attribute-Clustered Tables with Linear Ordering
• Attribute-Clustered Tables with Interleaved Ordering

supply chain