How does DTA make an index recommendation? What is the technology behind that? If we can use same on our side then we can shorten the whole process of Tuning recommendation:
- creating trace file using SQL Profiler
- Use that trace file in DTA
- Then look for recommendations
- Follow the recommendations & see the results in the Query Execution Plan.
I just wanted to know if it is there any way to create a predictable index.