Monday, March 30, 2015

count is very slow

table Structure is


(


ID bigint primary key,


Name Nvarchar(50)


);


record 50 millions


Query SQL


SELECT COUNT(ID) FROM U WHERE Name = '';


Query Time: over 3 minute


First time is very slow


How is Fast in first time???



No comments:

Post a Comment