clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3799161 fiddles created (41764 in the last week).

CREATE TABLE tab( id INT PRIMARY KEY, c INT INDEX filtered (c) WHERE c > 10, b VARCHAR(10) NOT NULL INDEX idx_tab_b, d VARCHAR(20) NOT NULL, INDEX my_index NONCLUSTERED(d) );
 hidden batch(es)


SELECT * FROM sys.indexes WHERE OBJECT_ID = OBJECT_ID('tab')
object_id name index_id type type_desc is_unique data_space_id ignore_dup_key is_primary_key is_unique_constraint fill_factor is_padded is_disabled is_hypothetical is_ignored_in_optimization allow_row_locks allow_page_locks has_filter filter_definition compression_delay suppress_dup_key_messages auto_created optimize_for_sequential_key
581577110 PK__tab__3213E83F6B43F0A6 1 1 CLUSTERED True 1 False True False 0 False False False False True True False False False False
581577110 my_index 2 2 NONCLUSTERED False 1 False False False 0 False False False False True True False False False False
581577110 idx_tab_b 3 2 NONCLUSTERED False 1 False False False 0 False False False False True True False False False False
581577110 filtered 4 2 NONCLUSTERED False 1 False False False 0 False False False False True True True ([c]>(10)) False False False
 hidden batch(es)