How long will essentially data in 15 million, add the index-CodePudding

Home > database > How long will essentially data in 15 million, add the index

How long will essentially data in 15 million, add the index

Time：10-04

This is my query SQL? Index was added to this, what advice would you Daniel

 select * from (select ROW_NUMBER () OVER (order by Service_Order_ID) as fuck, * from dbo. Temp_Cost_Tape_Cost_Raw_Data 
Where 1=1) as yyyy where fuck between 1 and 10000

The create index right?

 create clustered index SerId_Index 
On dbo. Temp_Cost_Tape_Cost_Raw_Data (Service_Order_ID) 
With (drop_existing=on)

Page link：https//www.codepudding.com/database/50754.html

Prev:Bosses consult. Db suffix format file with what software editing?

Next:SolidWorks

Tags：

problems

Links：
CodePudding