Это видео недоступно.
Сожалеем об этом.
Azure SQL Database: Columnstore indexes | Azure Friday
HTML-код
- Опубликовано: 4 авг 2024
- Davide Mauri is back with Lara Rubbelke to discuss columnstore indexes. In a typical relational database data is stored per row. This means that all row columns are saved together, which is great in all those cases where you want to retrieve all the information related to a specific row. But what if you want to have all the data stored in a subset of columns but for all the rows? That would be complex and slow-unless data was saved per-column instead of per-row. That's exactly what columnstore indexes in Azure SQL Database enables you to do.
Chapters
00:00 - Introduction
01:00 - Columnstore overview
07:00 - Demo: index creation
10:14 - Demo: querying with columnstore
13:53 - Demo: batch mode with LAG operator
15:00 - Wrap-up
Recommended resources
■ Columnstore indexes: Overview - aka.ms/azfr/724/01
■ Azure SQL Database - aka.ms/azfr/724/02
■ Niko Neugebauer on Columnstore - www.nikoport.com/columnstore/
■ Create a Pay-as-You-Go account (Azure) - aka.ms/azfr/724/payg
■ Create a free account (Azure) - aka.ms/azfr/724/free
Connect with us
■ Lara Rubbelke | @SQLGal - / sqlgal
■ Davide Mauri | @MauriDB - / mauridb
■ Azure Friday | @AzureFriday - / azurefriday
#Microsoft #Azure #AzureFriday #AzureSQL
impressive demo showing the great benefit of the columnstore index
impressive!
Can we use Columstore and Columstore noncluster together..
Hello David, thank you for this presentation. Is It possible to combine primary Keys with clustered column store index on the same table? Thank you
Nope , we need extra non clustered primary key index.
7:58
Indicies.