Index Template Parameters

  • Set template parametertrack_deletes when using the DeltaBTree index, which is used to provide table change information for remote materialized views. Use
    track_deletes=true
    to turn off tracking deletes.
  • Set template parameter . This parameter applies when using an index. For example,
    index.transaction_max_cache=1000
  • Set template parameter . This parameter applies when using an index. For example,
    index.transaction_min_cache=10
  • Set template parameter . This parameter applies when using an index. For example,
    index.btree_max_cache=1000
  • Set template parameter . This parameter applies when using an index. For example,
    index.btree_min_cache=10
  • Set template parameter . This parameter applies when using an index. For example,
    index.query_max_cache=100
  • Set template parameter . This parameter applies when using an index. For example,
    index.query_min_cache=5
  • Set template parameter . This parameter applies when creating an index with the API only. To create an unclustered index with the API use the template parameter and set
    clustered=false
    prior to calling the create index method.

  • Use this parameter to set the file directory for a specific index. This allows moving an index onto a separate disk, for example.
    index.file_directory="/newdrive/data/mydb/mycatalog/myschema"