With the advent of the era of LLMs, the demand for exploring multimodal data continues to grow. Queries over such data often involve hybrid workloads that combine structured attribute filtering with high-dimensional semantic matching. Efficient index advising for such hybrid query workloads is crucial for improving query performance. However, existing index advisors typically optimize individual types of queries in isolation and lack the capability to recommend scalar and vector indexes simultaneously for hybrid workloads. To address this limitation, this paper proposes HQIA, a hybrid query index advisor based on RIBE. Within this framework, we design a feature representation method tailored for hybrid queries, which integrates query cost and attribute distribution information. By incorporating physical query plans with histogram features, the method gains the ability to represent the predicate coverage of queries, thereby improving the distinguishability among different queries and ultimately enhancing workload compression and clustering. Building upon this foundation, we extend RIBE’s index advising mechanism to support hybrid queries. Experimental results show that HQIA achieves superior tuning effectiveness and significant performance improvements over existing methods in hybrid query scenarios.

错误:搜索内容不能为空,请输入英文关键词
错误:关键词超出字数限制,请精简
高级检索

HQIA: An Index Advisor for Hybrid Query Workloads

  • Kun Chao,
  • Kaijun Wen,
  • Kaige Wang,
  • Jiahao Li,
  • Peng Ren,
  • Chunxiao Xing

摘要

With the advent of the era of LLMs, the demand for exploring multimodal data continues to grow. Queries over such data often involve hybrid workloads that combine structured attribute filtering with high-dimensional semantic matching. Efficient index advising for such hybrid query workloads is crucial for improving query performance. However, existing index advisors typically optimize individual types of queries in isolation and lack the capability to recommend scalar and vector indexes simultaneously for hybrid workloads. To address this limitation, this paper proposes HQIA, a hybrid query index advisor based on RIBE. Within this framework, we design a feature representation method tailored for hybrid queries, which integrates query cost and attribute distribution information. By incorporating physical query plans with histogram features, the method gains the ability to represent the predicate coverage of queries, thereby improving the distinguishability among different queries and ultimately enhancing workload compression and clustering. Building upon this foundation, we extend RIBE’s index advising mechanism to support hybrid queries. Experimental results show that HQIA achieves superior tuning effectiveness and significant performance improvements over existing methods in hybrid query scenarios.