In Amazon RDS SQL Server (any version/edition), create a temp table and update statistics on it. This works fine:
IF OBJECT_ID('tempdb..#t') IS NOT NULL DROP TABLE #t; GO CREATE TABLE #t (id INT NOT NULL); GO UPDATE STATISTICS #t GO
But try to specify the rowcount on the statistics:
UPDATE STATISTICS #t WITH ROWCOUNT = 100000000; GO
And you get an error:
Msg 1088, Level 16, State 12, Line 1 Cannot find the object "#t" because it does not exist or you do not have permissions.
The STATS_STREAM, ROWCOUNT, and PAGECOUNT options are documented, but not officially supported. Is there a workaround for AWS RDS SQL Server so that they work?