sql_functions_reference/59_index_single-multi_column_index.sql at main · vishnu-t-r/sql_functions_reference · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

--single column index
create index ss_rowid_index
on Sample_Superstore (Row_ID);

--index on muliple columns
create index ss_multi_index
on Sample_Superstore (Row_ID,Order_ID);

create index ss_multi_index01
on Sample_Superstore (Product_ID,Order_ID);


--drop index
drop index Sample_Superstore.ss_multi_index;


--SELECT * FROM Sample_Superstore

--SELECT COUNT(*) FROM Sample_Superstore

--select distinct Row_ID,Order_ID from Sample_Superstore

EXECUTE sp_helpindex Sample_Superstore