CREATE CLUSTERED INDEX <index_name> ON <table_name>(<column_name> ASC/DESC) Example - CREATE CLUSTERED INDEX IX_tblBook_Price ON Books(price ASC) -- Here books is table and price is column