Conf File

A .conf file is a single ADW.conf file that contains constructs such as indexes, column groups, and partitions for PROTECTED and PUBLIC datasets.

You can use .conf files to improve performance of reporting queries in the database.

The file has a .conf extension.

A .conf file contains:

• Column groups: A set of columns in a single dataset that's treated as a single unit for query performance.
  Example:

  COLUMNGROUPS
  [
     CREATE COLUMNGROUP COL_SALES1 ON SALES[CUST_ID, SALE_ID];
     CREATE COLUMNGROUP COL_CUSTOMER ON CUSTOMER[CUST_ID, CUST_NAME];
  ]
  

• Indexes: A quick lookup of data in a column or columns of a table using B-Tree indexing.
  Example:

  INDEXES 
  [
      CREATE NON-UNIQUE INDEX city_index ON CUST_D[CUST_CITY, COUNTRY_ID];
      CREATE UNIQUE INDEX unique_city_indx ON CUST_D[CUST_ID, CUST_FIRST_NAME];
  ]
  

• Partitions: A partition allows tables, indexes, and index-organized tables to be subdivided into smaller pieces for managing and accessing them at a finer level of granularity. A table can have only one partition.
  Example:

  PARTITIONS
  [
      // LIST 
      CREATE LIST PARTITION ON PRODUCT_SALES[PROD_CATEGORY];
  ]