Index tuning using sql script

[nour]

Is it possible to achieve Index tuning using sql script within Query Analyser when being just a db_owner and not sysadmin.
In case the answer is yes, would you please provide any link to help or examples.

Thanks

[rmiao]

What's 'Index tuning using sql script within Query Analyser'?

[nour]

I mean writting a SQL script to do the tuning instead of using the wizzard??

[rmiao]

Can't do that with sql script.

[skhanal]

You can however run the query in query analyzer and see execution plan, it will indicate where you are doing full scans or which statistics are missing.