but i was told to install that particular only to the prod database. please if you help me in this. and do after installing Hotfixes do we need to restart...

But pradeep i do not find the particular hotfix. or can you please send me the link where i will find this HotFix.

The hot fix is 41609.

I would appreciate.

so deleting indexes that have reads 0 is a good idea?

i found this thru the performance dashboard......... any help please.