SQL FORCESEEK
http://decipherinfosys.wordpress.com/2007/12/20/forceseek-table-hint-in-sql-server-2008/
Here is the data distribution that was created by this small script:
SELECT COL2, COUNT(*) AS REC_CNT
FROM BIG_TABLE
GROUP BY COL2
ORDER BY COL2;
COL2 REC_CNT
---- -----------
0 10
10 99990
90 900000
Now, let us...
[read more]
Submit a review:
Login required.