Home Microsoft SQL Server DigiMailing Contact
    Keyword



  On Index Microsoft SQL Server supplies you with the following objects:

Procedure
  • sys.sp_cdc_create_change_table_index
  • sys.sp_cdc_verify_index_name
  • sys.sp_helpindex
  • sys.sp_help_spatial_geography_index
  • sys.sp_help_spatial_geography_index_helper
  • sys.sp_help_spatial_geography_index_xml
  • sys.sp_help_spatial_geometry_index
  • sys.sp_help_spatial_geometry_index_helper
  • sys.sp_help_spatial_geometry_index_xml
  • sys.sp_help_spatial_index_internal
  • sys.sp_IHscriptindexes
  • sys.sp_IHVerifyIndex
  • sys.sp_indexcolumns_managed
  • sys.sp_indexes
  • sys.sp_indexes_100_rowset
  • sys.sp_indexes_100_rowset2
  • sys.sp_indexes_90_rowset
  • sys.sp_indexes_90_rowset2
  • sys.sp_indexes_90_rowset_rmt
  • sys.sp_indexes_managed
  • sys.sp_indexes_rowset
  • sys.sp_indexes_rowset2
  • sys.sp_indexes_rowset_rmt
  • sys.sp_indexoption
  • sys.sp_ivindexhasnullcols
  • sys.sp_MSaddguidindex
  • sys.sp_MShelpfulltextindex
  • sys.sp_MShelpindex
  • sys.sp_MSindexcolfrombin
  • sys.sp_MSindexspace
  • sys.sp_MSmerge_dropindex
  • sys.sp_MStable_has_unique_index


  • View
  • sys.dm_db_index_usage_stats
  • sys.dm_db_missing_index_details
  • sys.dm_db_missing_index_groups
  • sys.dm_db_missing_index_group_stats
  • sys.dm_fts_index_population
  • sys.fulltext_indexes
  • sys.fulltext_index_catalog_usages
  • sys.fulltext_index_columns
  • sys.fulltext_index_fragments
  • sys.indexes
  • sys.indexes$
  • sys.index_columns
  • sys.index_counts
  • sys.spatial_indexes
  • sys.spatial_index_tessellations
  • sys.spt_indexcolumns_view_managed
  • sys.spt_indexes_view
  • sys.spt_indexes_view_100
  • sys.spt_indexes_view_managed
  • sys.sysindexes
  • sys.sysindexkeys
  • sys.xml_indexes