sql server - How to get Information about indexes of system views -


How can I get information about the index of system views?

I write this question and I see the execution. I saw this index rather index seek. Any one scan used to know why 

  select OBJECT_NAME ( Object_id) TableName, ST.row_count from sys.dm_db_partition_stats ST index_id & lt; 2 and OBJECT_NAME (object_id) = 'Mytbl'   
 Enter image details here   
 
 
  idx_name, i.type_desc, i.is_unique, ac Choose. Name COL_NAME, c.key_ordinal, c.is_descending_key, c.is_included_column as sys.indexes as i join sys.all_objects one at a.object_id = i.object_id c.object_id = i.object_id and c.index_id Join sys.index_columns c = i.index_id ac.object_id = i.object_id and c.column_id = ac.column_id to join sys.all_columns ac where a.name = 'sysidxstats'   
 returns  
  idx_name type_desc is_unique col_name key_ordinal is_descending_key is_included_column ----------------- ----------- ---- ------ --- ----------- ----------- --------------- -------- ---------- CLST Cluster 1 ID 1 CLST Cluster 1 indid 2 0 nc nonclustered 1 Name 1 0 0 nonclustered nc 1 ID 2 0   
 C Do  
  Select Objedn (Object_id) Talikanam, sys.dm_db_partition_stats the st.row_count st WHERE index_id & lt; 2 and object_id = OBJECT_ID ('Mytbl')   
 To get an index.  
 plan with SEEK  
  where objects ( Object_id) = 'miteball'  is not a searchable special.

Comments

Post a Comment