Santhosh Subramaniam

Santhosh Subramaniam

  • NA
  • 226
  • 108.3k

Parallel SQL Query Execution..?

Mar 1 2014 5:56 AM
Hi frnds,
 

Create Table #City(CityName varchar(40))

insert into #City

select top 5 City from State where Name='TamilNadu' order by City

insert into #City

select top 5 City from State where Name='Kerala' order by City

Select Top 5 * from #City order by City
 
Frnds this is sample Query ,
 
in my SQL Server database around 5laks records is there , when i get all data from table and  fetch top 5 records means it will take long time to execute
how can i execute these 2 queries in same time . 

Answers (1)