February 19, 2017

Create Index From SQL of Expensive queries

Index creation from expensive query from SQL You can use Activity monitor of SQL .
Activity Monitor

Then you can find missing index detail from show execution plan by right click on query.
show execution plan
Add caption

If its ax then you can create it from AOT step provided at the end of video.