탐색 건너뛰기

Azure SQL Data Warehouse: Secondary indexes on column store now available

2017년 1월 18일 수요일

In Azure SQL Data Warehouse, you can now create secondary B-Tree indexes on column store tables.

Most analytic queries aggregate large amounts of data and are served well by scanning the column store segments directly. However, there is often a need to look for a "needle in a haystack," which translates to a query that does a lookup of a single row or a small range of rows. Such lookup queries can get an improvement in response time in orders of magnitude (even 1,000 times) and potentially run in sub-second if there is a B-Tree index on the filter column.

To create a secondary index on a column store table, follow the same syntax as the generic Create Index Transact-SQL statements.

 

 

 

 

 

계정 등록

Azure 크레딧 $200을 얻고 인기 서비스를 12개월 간 체험해 보세요.

시작

Visual Studio

최대 $1800 연간 Azure 서비스를 구독자에게 제공

지금 활성화

스타트업

Microsoft for Startups에 참가하고 체험 Azure 서비스 받기

자세한 정보