Manage file indexes
InfluxDB 3 Enterprise lets you customize how your data is indexed to help optimize query performance for your specific workload, especially workloads that include single-series queries. Indexes help the InfluxDB query engine quickly identify the physical location of files that contain the queried data.
By default, InfluxDB indexes on the primary key—time
and tag columns. However,
if your schema includes tags that you don’t specifically use when querying, you
can define a custom indexing strategy to only index on time
and columns
important to your query workload.
For example, if your schema includes the following columns:
- country
- state_province
- county
- city
- postal_code
And in your query workload, you only query based on country, state or province,
and city, you can create a custom file indexing strategy that only indexes on
time
and these specific columns. This makes your index more efficient and
improves the performance of your single-series queries.
File indexes can use any string column, including both tags and fields.
Indexing life cycle
InfluxDB 3 Enterprise builds indexes as it compacts data. Compaction is the process that organizes and optimizes Parquet files in storage and occurs in multiple phases or generations. Generation 1 (gen1) data is un-compacted and is not indexed. Generation 2 (gen2) data and beyond is all indexed.
Create a custom file index
Use the influxdb3 create file_index
command to create a custom file indexing strategy for a database or a table.
influxdb3 create file_index \
--database example-db \
--token 00xoXX0xXXx0000XxxxXx0Xx0xx0 \
--table wind_data \
country,city
Delete a custom file index
Use the influxdb3 delete file_index
command to delete a custom file indexing strategy from a database or a table and revert to the default indexing strategy.
influxdb3 delete file_index \
--database example-db \
--token 00xoXX0xXXx0000XxxxXx0Xx0xx0 \
--table wind_data
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB 3 Enterprise and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support. Customers using a trial license can email trial@influxdata.com for assistance.