1B row vector search in less than a second with Azure SQL Database Hyperscale | Data Exposed

Learn about vector indexing in Microsoft SQL from the PM and engineering team. ✅ Chapters: 0:00 Intro to Product Management and Engineering vector team 1:13 What things were customers asking for. Example scenario: support team looking for similar or related cases 2:02 Everything's fine but now it needs to scale better, so we built and index 2:37 Anna asks why can't we just use exact search? 2:59 Intro to DiskANN - a graph-based vector index 3:35 Why is it called DiskANN 4:30 Next customer asks for not just vector search but also iterative filtering 5:50 Anna reacts to iterative filtering vs post-filtering 6:33 Next customer asks for insert, update, delete, without needing to update the index 7:05 DML vector demo 8:00 Approximate vs exact vector search, handled by optimizer 10:20 Next customer asks to search on 1 billion rows 10:49 Vector search still returns within milliseconds 11:17 Pooja reacts to all the customers asks being met so far 12:05 Vector Index in Azure SQL PaaS and Fabric SQL is now generally available! ✅ Let's connect: LinkedIn - Pooja Kamath LinkedIn - Krithika Subramanian Twitter - Anna Hoffman, https://twitter.com/AnalyticAnna Twitter - AzureSQL, https://aka.ms/azuresqltw 🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQL #LearnSQL