SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE dbo.table_a
(col_a int, col_b int, col_c int);

CREATE CLUSTERED INDEX thetable ON dbo.table_a(col_a,col_b,col_c);

INSERT dbo.table_a(col_a, col_b, col_c)
VALUES(1,5,10),(10,5,1);
2 rows affected

SELECT * FROM table_a;


col_a
col_b
col_c


1
5
10

10
5
1


CREATE INDEX not_thetable ON dbo.table_a(col_c,col_b,col_a);
SELECT * FROM table_a;


col_a
col_b
col_c


10
5
1

1
5
10