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