indexes with unspecific columns
The SQL Server knows only about the column content if you're creating a index or a statistic for this column. If the companyID is always populated with 1 you never want to create an index for it - not even as last part of a multi column index. The recommended indices are sometimes stupid and should be considered as guess.