CREATE TABLE Phone (

Phone_ID int IDENTITY(1,1) NOT NULL,

Contract_No int NOT NULL,

Make varchar(20) NULL,

Model_No int NULL,

Year smalldatetime NULL,

Warranty varchar(20) NULL,

User_ID varchar(10) NULL,

City varchar(20) NULL,

Status varchar(10) NULL

)

Query1:

SELECT Contract_No, Make, Model_No, Year

FROM Phone

WHERE Contract_No = @Contract_No AND Status = 'Active'

Query2:

SELECT Contract_No, Make, Model_No, Status

FROM Phone

WHERE Contract_No = @Contract_No AND Year > '2007-12-31'

Query3:

SELECT Contract_No, Make, Model_No

FROM Phone

WHERE Contract_No = @Contract_No

Since Phone_ID has a primary key, it has Clustered index already.

I assume non-clustered index will contain columns Contract_No, Make, Model_No

Regards

Kevin