I am facing an issue in my query return data is too slow , Obviously there are some indexes missing on those table .Trick is when you run query Include Actual execution plan so it will suggest these are the missing indexes if you include this it will make your query faster.
Then just right click and click Missing index detail run that query and see the magic :)
No comments:
Post a Comment