To expand on what george said, does your primary key for the table include a lot of columns? The entire key for the table will be included in the index.
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'