Doctoral Speaking Skills Talk - Sam Arch February 25, 2025 12:00pm — 1:00pm Location: In Person - Blelloch-Skees Conference Room, Gates Hillman 8115 Speaker: SAM ARCH, Ph.D. Student, Computer Science Department, Carnegie Mellon University https://samarch.xyz/ User-defined functions (UDFs) are procedural functions (written in PL/SQL, Python) callable from SQL queries. However, queries with UDFs are notoriously hard to optimize as they mix declarative SQL and procedural UDF code. In SQL Server 2019, Microsoft shipped UDF inlining, a feature eliminating all UDF code by translating entire UDFs to SQL. However, inlining often leads to sub-optimal performance. We propose a new optimization technique, UDF outlining, to intentionally hide pieces of a UDF from the query optimizer, resulting in significantly simpler and faster queries. Presented as part of the Database Group Lunch Talks Presented in Partial Fulfillment of the CSD Speaking Skills Requirement Add event to Google Add event to iCal
