Skip to main content
Version: User Guides (BYOC)

STL_SORT

The STL_SORT index is an index type specifically designed to enhance query performance on numeric fields (INT8, INT16, etc.), VARCHAR fields, or TIMESTAMPTZ fields within Zilliz Cloud by organizing the data in a sorted order.

Use the STL_SORT index if you frequently run queries with:

  • Comparison filtering with ==, !=, >, <, >=, and <= operators

  • Range filtering with IN and LIKE operators

Supported data types​

How it works​

Zilliz Cloud implements STL_SORT in two phases:

  1. Build index

    • During ingestion, Zilliz Cloud collects all values for the indexed field.

    • The values are sorted in ascending order using C++ STL’s std::sort.

    • Each value is paired with its entity ID, and the sorted array is persisted as the index.

  2. Accelerate queries

    • At query time, Zilliz Cloud uses binary search (std::lower_bound and std::upper_bound) on the sorted array.

    • For equality, Zilliz Cloud quickly finds all matching values.

    • For ranges, Zilliz Cloud locates the start and end positions and returns all values in between.

    • Matching entity IDs are passed to the query executor for final result assembly.

This reduces query complexity from O(n) (full scan) to O(log n + m), where m is the number of matches.

Create an STL_SORT index​

You can create an STL_SORT index on a numeric or TIMESTAMPTZ field. No extra parameters are required.

The example below shows how to create an STL_SORT index on a TIMESTAMPTZ field:

from pymilvus import MilvusClient

client = MilvusClient(uri="YOUR_CLUSTER_ENDPOINT") # Replace with your server address

# Assume you have defined a TIMESTAMPTZ field named "tsz" in your collection schema

# Prepare index parameters
index_params = client.prepare_index_params()

# Add RTREE index on the "tsz" field
index_params.add_index(
    field_name="tsz",
    index_type="STL_SORT",   # Index for TIMESTAMPTZ
    index_name="tsz_index",  # Optional, name your index
    params={}                # No extra params needed
)

# Create the index on the collection
client.create_index(
    collection_name="tsz_demo",
    index_params=index_params
)

Drop an index​

Use the drop_index() method to remove an existing index from a collection.

📘Notes

In your cluster compatible with Milvus v2.6.x, you can drop a scalar index directly once it’s no longer needed—no need to release the collection first.

client.drop_index(
    collection_name="tsz_demo",   # Name of the collection
    index_name="tsz_index" # Name of the index to drop
)

Usage notes​

  • Field types: Works with numeric and TIMESTAMPTZ fields. For more information on data types, refer to Boolean & Number and TIMESTAMPTZ Field.

  • Parameters: No index parameters are needed.

  • Mmap not supported: Memory-mapped mode is not available for STL_SORT.