If i can get pros and cons of each type of input to database engine tuning advisor then that will be help full?

(Any link will be help full)

yours sincerely

Thank you for links, i am brushing up .

Database Engine Tuning Advisor uses trace files, trace tables, Transact-SQL scripts, or XML files as workload input when tuning databases.

So please tel...

Please confirm

query no 1) and 2) will not get the benefit of alignment/collocation,

if i use them in exists or derived table?

yours sincerly

thank you,

but my question is still not answered.

yours sincerly.

yes i have cheked all possible things,

and finally came to conclusion that making one flat table would be good idea.

so all my queries are related to this flat table. and...

I am trying to get speed by making one table out of many table joins from queries.

and collocation is stroger form of alignment of partitioning (mssql 2005)

note:(I tried to change...