SQL Server 2017 auto create/drop indexes

It appears that Azure really is the testing ground for new features.
 
As shown in the previous blog the addition of auto index maintenance in Azure, we now see new columns in the sys.indexes view in the SQL Server 2017 CTPs.
image

SELECT 
'[' + OBJECT_SCHEMA_NAME([object_id]) + '].[' + OBJECT_NAME([object_id]) + ']' AS table_name
,[name] AS index_name
,auto_created,is_ignored_in_optimization,suppress_dup_key_messages
FROM sys.indexes;

So watch this space.

Leave a Reply