Ok thanks - in test system i have started to drop and edit indexes where they are covered/included with clustered index. I was wondering should i then run dbcc freeproccache...

I was looking in forums and came across this post.

Here Adi has made a point about size of nc index in comparison to clustered....which makes some sense to me...

We have prob over 30 indexes in total on our db where DTA has recommended using clustered index on covering index or as include - i am concerned that this...

There are exam prep kits that you can buy that include simulations, or you could just google it