Thanks for the info,

Does it exist a table/query that cann tell us if a table is more used for select or insert/update/delete ??

my small contribution for this great query, a collumn which will generate the create index statement

'CREATE NONCLUSTERED INDEX IX_'+replace((right (mid.[statement],len (mid.[statement])-

charindex (']',mid.[statement],charindex (']',mid.[statement],0)+3)-2)) ,']','')

+isnull(replace (replace (replace (mid.equality_columns,'[','_'),']',''),', ',''),'')

+isnull(replace (replace (replace (mid.inequality_columns,'[','_'),']',''),', ',''),'')

+isnull(replace (replace (replace (mid.included_columns,'[','_'),']',''),', ',''),'')

+ ' ON ' + mid.[statement]

+ replace (' (' +isnull(mid.equality_columns,'')+isnull(+mid.inequality_columns,''),'][','],[')+ ')'

+isnull ('INCLUDE ('+included_columns +');',';' )

I guess it can be improved, if so, please let me know your point of view.

Thanks again.