DDL : Creating an index

create unique clustered index emp_idx
on employee (emp_id)
go

create index emp_name_idx
on employee (lname)
go


-- With sorted data!

create unique clustered index pk_invoice_data on invoice_data with sorted_data on segment1
go