Temat: MS SQL: SQL Server Managment Studio 2014
...
WHERE ((DATAAREAID=?)
AND ((INVENTTRANSID=?)
AND (ITEMID=?)))
ORDER BY A.DATAAREAID,A.INVENTTRANSID OPTION(FAST 1)
na tabeli jest 7 indeksow
field name, data type, size, identity, allow nulls
DATAAREAID nvarchar(4) 8 No No
INVENTBATCHID nvarchar(20) 40 No No
INVENTTRANSID nvarchar(20) 40 No No
PANELROUNDING numeric(28,12) 13 No No
.
DATAAREAID nvarchar(4) 8 No No
PANELORGREFRECID bigint 8 No No
.
DATAAREAID nvarchar(4) 8 No No
INVENTTRANSID nvarchar(20) 40 No No
.
DATAAREAID nvarchar(4) 8 No No
PRODINVENTTRANSID nvarchar(20) 40 No No
PANELDIMSPECINVENTTRANSID nvarchar(20) 40 No No
UNDERCUTTYPEID nvarchar(1) 2 No No
PANELLENGTH int 4 No No
.
DATAAREAID nvarchar(4) 8 No No
QUOTATIONINVENTTRANSID nvarchar(20) 40 No No
.
DATAAREAID nvarchar(4) 8 No No
RECID bigint 8 No No
.
DATAAREAID nvarchar(4) 8 No No
SALESID nvarchar(20) 40 No No
INVENTTRANSID nvarchar(20) 40 No No
PACKNO int 4 No No