Hi,

Your two nonclustered indexes are not used by your select * query. Use clustered index instead. You can extend your nonclustered indexes with INCLUDE(col1,col2,...coln) but you have to add a WHERE clause that will make a use of it.

You can find some articles on indexes http://www.sqlservercentral.com/search/?q=indexing&t=a

Clustered index is the best choice in your case.

Regards,

IgorMi