Reindexing is a big issue here.  I'm new to the company and the database is a vendor supplied system.  I'm working with them at the moment.

The clustered index looks good in all area's.  I reindexed the table yesterday and within 5 hours, a couple of the non clustered indexes had a scan density of around 40%.  The clustered index stayed above 90%.

As the databases are all hospital sites, the downtime scheduling is quite sensitive.