CREATE NONCLUSTERED INDEX

Örnek

Şöyle yaparız

CREATE NONCLUSTERED INDEX IDX_MYINDEX

ON Orders(OrderDate, ProductID);

Query Store

Giriş

Açıklaması şöyle

The Query Store in SQL Server is a feature designed to help you monitor, troubleshoot, and optimize query performance by automatically capturing a history of queries, plans, and runtime statistics. It's essentially a performance monitoring and tuning tool built into SQL Server.

Örnek

Şöyle yaparız

ALTER DATABASE AdventureWorks SET QUERY_STORE = ON;

SQL Server Management Studio

Generate Scripts

Database simgesine sağ tıkla ve Tasks/Generate Scripts menüsünü seç