Thanks everybody for sharing your knowledge and experience. Today i have installed minion re-index script and run the jobs for my database, it did't improve too much. Comparing to maintenance...

Here is the result of Fill Factor query.

schemaName, tablename, indexname, fillfactor

dbo Items ...

Hi Everybody

Thanks a lot for useful information. now i have understand the CI and NCI better than before.

@chris-2 Harshman: yes its a third party CMS system (Sitecore).

@SQLRNNR: why maintenance...