Connect with us

Adelaide News

The 201 Buckets Problem, Part 1: Why You Still Don’t Get Accurate Estimates

(fixfix) I’ll start with the smallest Stack Overflow 2010 database and set up an index on Location: [crayon-5f0493800c84b872738458/] There are about 300,000 Users – not a lot, but enough that it will start to give SQL Server some estimation problems: When you…

Published

on

post featured image

(fixfix)
I’ll start with the smallest Stack Overflow 2010 database and set up an index on Location:
USE StackOverflow2010
GO
CREATE INDEX Location ON dbo.Users(Location);
GO
SELECT COUNT(*) FRO…

Click here to view the original article.

Continue Reading
Advertisement

You might also like ...

Hospital patients under guard as govt misses key mental health target
Your views: on unvaccinated medi-hotel workers and more