EUVIMEDEUVIMED entdecken
Crossref

Partial UDF Inlining

Samuel Arch, Yuchen Liu, Todd C. Mowry, Jignesh M. Pate, Andrew Pavlo

ACM SIGMOD Record · 23.04.2026 · 55 (1) · 74-83

DOI: 10.1145/3810900.3810914 ↗

Kurz gefasst

Fachartikel in der Zeitschrift ACM SIGMOD Record, online erschienen am 23.04.2026. Verfasst von Samuel Arch und 4 weiteren Autor:innen. Die Arbeit nennt 50 Literaturangaben.

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

Although user-defined functions (UDFs) are a popular way to augment SQL's declarative approach with procedural code, the mismatch between programming paradigms creates a fundamental optimization challenge. UDF inlining automatically removes all UDF calls by replacing them with equivalent SQL subqueries. Although inlining leaves queries entirely in SQL (resulting in large performance gains), we observe that inlining the entire UDF often leads to suboptimal performance. A better approach is to analyze the UDF, deconstruct it into smaller pieces, and inline only the pieces that help query optimization. To achieve this, we propose UDF outlining, a technique to intentionally hide pieces of a UDF from the optimizer, resulting in simpler UDFs and significantly faster query plans. Our implementation (PRISM) demonstrates that UDF outlining improves performance over conventional inlining (on average 1.29× speedup for DuckDB and 298.73× for SQL Server) through a combination of more effective unnesting, improved data skipping, and by avoiding unnecessary joins.

Zitieren

APA

Arch, S., Liu, Y., Mowry, T. C., Pate, J. M., & Pavlo, A. (2026). Partial UDF Inlining. ACM SIGMOD Record, 55(1), 74-83. https://doi.org/10.1145/3810900.3810914

Vancouver

Arch S, Liu Y, Mowry TC, Pate JM, Pavlo A. Partial UDF Inlining. ACM SIGMOD Record. 2026;55(1):74-83. doi:10.1145/3810900.3810914

BibTeX
@article{Arch2026,
  author = {Arch, Samuel and Liu, Yuchen and Mowry, Todd C. and Pate, Jignesh M. and Pavlo, Andrew},
  title = {Partial UDF Inlining},
  journal = {ACM SIGMOD Record},
  year = {2026},
  volume = {55},
  number = {1},
  pages = {74--83},
  doi = {10.1145/3810900.3810914}
}
Kostenlos starten →