DROP TABLE IF EXISTS CurrencyShareds ;

CREATE TABLE CurrencyShareds  (Id BIGINT, CONSTRAINT PK_id PRIMARY KEY (id));

INSERT INTO CurrencyShareds VALUES
(119762190797406464),
(119762190797406465),
(119762190797406466),
(119762190797406467),
(119762190797406468),
(119762190797406469),
(119762190797406470),
(119762190797406471),
(119762190797406472),
(119762190797406473),
(119762190797406474),
(119762190797406475),
(119762190797406476),
(119762190797406477),
(119762190797406478),
(119762190797406479),
(119762190797406480),
(119762190797406481),
(119762190797406482),
(119762190797406483),
(119762190797406484),
(119762190797406485),
(119762190797406486),
(119762190797406487),
(119762190797406488),
(119762190797406489),
(119762190797406490),
(119762190797406491),
(119762190797406492),
(119762190797406493),
(119762190797406494),
(119762190797406495),
(119762190797406496),
(119762190797406497),
(119762190797406498),
(119762190797406499),
(119762190797406500),
(119762190797406501),
(119762190797406502),
(119762190797406503),
(119762190797406504),
(119762190797406505),
(119762190797406506),
(119762190797406507),
(478531702587687680),
(478531702591881728),
(478531702591881729),
(478531702591881984),
(478531702591881985),
(478531702596076032),
(478531702596076033),
(478531702596076288),
(478531702600270336),
(478531702600270592),
(478532235583062528),
(478532235583062784),
(478532235587256832),
(530792464911467264),
(530792464924049920),
(530792464924050176),
(530792464928244224),
(530792464928244480),
(530792464932438528),
(530792464932438784),
(530792464936632832),
(530792464936632833),
(530792464936633088),
(530792464940827136),
(530792464940827392),
(530792464945827392), -- guessed
(530792464950827392), -- guessed
(530792464949216000),
(530792464953410048),
(530792464953410304),
(530792464957604352),
(530792464957604353),
(530792464957604608),
(530792464961798656),
(530792464961798912),
(530792464965992960),
(530792464965993216),
(530792464965993217),
(530792464970187264),
(530792464970187265),
(530792464970187520),
(530792464974381568),
(530792464974381824),
(530792464974381825),
(530792464978575872),
(530792464978575873),
(530792464978576128),
(867420708903354880),
(867420708903355136),
(867420708903355137),
(960876568220042240),
(976385263448130048),
(977302121709864192),
(977955748426318592);


UPDATE STATISTICS CurrencyShareds Pk_Id

DBCC SHOW_STATISTICS (CurrencyShareds, Pk_Id);

--CREATE STATISTICS S ON CurrencyShareds (Id);





DROP TABLE IF EXISTS annexes ;

CREATE TABLE annexes  (Amount_TransactionCurrency_id BIGINT);


INSERT INTO annexes WITH (TABLOCK)
SELECT TOP (160) 119762190797406475
FROM master..spt_values;


INSERT INTO annexes WITH (TABLOCK)
SELECT TOP (867) 119762190797406478
FROM master..spt_values;


INSERT INTO annexes WITH (TABLOCK)
SELECT TOP (106) 119762190797406481
FROM master..spt_values;


INSERT INTO annexes WITH (TABLOCK)
SELECT TOP (105742) 119762190797406494
FROM master..spt_values t1
CROSS JOIN master..spt_values t2;

INSERT INTO annexes WITH (TABLOCK)
SELECT TOP (329) 119762190797406496
FROM master..spt_values t1
CROSS JOIN master..spt_values t2;

CREATE STATISTICS S ON annexes (Amount_TransactionCurrency_id);

DBCC SHOW_STATISTICS (annexes, S);