title: Sys.Indexes items are missing from sys.objects view SQL Server 2014
body: <p>I have just installed SQL Server 2014.</p>
  
  <ul>
  <li>Product: Microsoft SQL Server Express (64-bit) <br></li>
  <li>Operating System: Microsoft Windows NT 6.1 (7601)<br></li>
  <li>Platform: NT x64<br></li>
  <li>Version: 12.0.2000.8<br></li>
  <li>Server Collation: Latin1_General_CI_AS<br></li>
  <li>Is Clustered: False <br></li>
  <li>Is HADR Enabled: False<br></li>
  </ul>
  
  <p>I created a database using right click on Databases --> New Database. I set a name, I left the default options and I pressed OK. </p>
  
  <p>Executing the following query, I realized that there are items from <code>sys.indexes</code> view that cannot be found in <code>sys.objects</code>.</p>
  
  <pre><code>Select * 
  From sys.indexes ind
  Where not exists ( select * from sys.objects obj where ind.object_id = obj.object_id )
  </code></pre>
  
  <p>The above query returns the following results: </p>
  
  <pre><code>5575058         plan_persist_plan_cidx
  5575058         plan_persist_plan_idx1
  21575115        plan_persist_runtime_stats_cidx
  21575115        plan_persist_runtime_stats_idx1
  37575172        plan_persist_runtime_stats_interval_cidx
  37575172        plan_persist_runtime_stats_interval_idx1
  53575229        plan_persist_context_settings_cidx
  2121058592      plan_persist_query_text_cidx
  2121058592      plan_persist_query_text_idx1
  2137058649      plan_persist_query_cidx
  2137058649      plan_persist_query_idx1
  </code></pre>
  
  <p>I read that non schema-scoped items are not returned from <code>sys.objects</code> view, but I cannot find any information related to the above items. Until today I used SQL Server 2012 and I didn't have any problem with the above table connection logic. </p>
  
  <p>What kind of items are these? </p>
  
  <p>How can I distinguish these items from other (other=the items returned from <code>sys.objects</code>)?</p>
  
  <p>Thanks,<br>
  Kostas</p>