Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE IF EXISTS dbo.ODD;
- CREATE TABLE dbo.ODD (
- ID BIGINT NOT NULL,
- FLUFF VARCHAR(10)
- );
- INSERT INTO dbo.ODD WITH (TABLOCK)
- SELECT TOP (100000)
- -1 + 2 * ROW_NUMBER() OVER (ORDER BY (SELECT NULL))
- , REPLICATE('FLUFF', 2)
- FROM master..spt_values t1
- CROSS JOIN master..spt_values t2;
- CREATE STATISTICS S ON dbo.ODD (ID) WITH FULLSCAN;
- DROP TABLE IF EXISTS dbo.EVEN;
- CREATE TABLE dbo.EVEN (
- ID BIGINT NOT NULL,
- FLUFF VARCHAR(3500)
- );
- INSERT INTO dbo.EVEN WITH (TABLOCK)
- SELECT TOP (100000)
- 1000 * FLOOR ( ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) / 500)
- , REPLICATE('FLUFF', 700)
- FROM master..spt_values t1
- CROSS JOIN master..spt_values t2
- CREATE STATISTICS S ON dbo.EVEN (ID) WITH FULLSCAN;
- CREATE OR ALTER VIEW dbo.TRICKY_VIEW AS
- SELECT o.ID
- FROM dbo.ODD o
- WHERE NOT EXISTS (
- SELECT 1
- FROM dbo.EVEN e WHERE o.ID = e.ID
- );
- SELECT TOP 500 *
- FROM dbo.TRICKY_VIEW
- OPTION (MAXDOP 1);
Add Comment
Please, Sign In to add comment