SQL Profiler + indexes

2004-09-18 03:28:34 AM
There are many routines at my system that i am sure i can speed up, by
creating indexes on their related tables.
How can i use the Profiler, so he can automatically generate all the
indexes for me.
I know this is based in a workload file, but, what kind of trace
template should i use??
And why when at the tunning wizard, based in a workload, i have to
select all tables i want manually.??