SQL Indexxxxxxxcesss

create database Hamza

use Hamza

drop table Hamza

create table Hamza(id int , sal int , name varchar(255), country varchar(255),city varchar(255))

insert into Hamza values(1,100,'hamza' ,'Australia' , 'Pakistan')

insert into Hamza values(2,50,'hamza' ,'England' , 'karachi')

insert into Hamza values(3,1000,'hamza' ,'Africa' , 'Baldia Town')

select * from Hamza

select max(sal) from Hamza

sp_helpindex Hamza

create clustered index Hmmindex on Hamza(country asc,city desc)

create nonclustered index Hmmindex on Hamza(country asc,city desc)
set statistics time on