Bad performance need index tuning

oliverbi 2013-10-18 17:45:41

Hello,

Seems that i got problem with index.
i try to create one with the 4 columns, but seems that it can not be possible.
someone can help me please ?
thanks

swasheck 2013-10-18 18:06:38
It looks like you do not have a clustered index on [Table1], but you have at least two nonclustered indexes. I'd start by identifying a clustering key that constitutes your most selective data.