Create and Manage indexes using Management Studio Please delete all the indexes on EMPLOYEE table and WORK_ON

Fantastic news! We've Found the answer you've been seeking!

Question:

Create and Manage indexes using Management Studio

Please delete all the indexes on EMPLOYEE table and WORK_ON table first.

(a) Create an unique, non-clustered index named “emp_ssn” for the EMPLOYEE table : the index key is "SSN ", and the fill factor is 80%.

For example:

Indexes/Keys Selected Primary/Unique Key or Index: IX_Department* Add Delete Editing properties for new

Rename the emp_ssn index to ix_emp_ssn.

(c) Drop the ix_emp_ssn index.

(2) Create and Manage indexes using Transact-SQL

(a) Create an unique, non-clustered index named “emp_ssn” for the EMPLOYEE table : the index key is "SSN ", and the fill factor is 80%.

SQL Text：

Screenshot of result：

(b) Rename the emp_ssn index to ix_emp_ssn. (Hint: use the sp_rename stored procedure)

(c) Create a non-clustered index named “emp_project_index” for the WORK_ON table : the index key is "ESSN(asc) " and “PNO(desc)”, and the fill factor is 50%.