, , , SQL , . . , , SQL Server , , . .
, , . , , . .
, , FROM . , .
, . , , . , . , , , - . .
:
- , .
- , .
, OLTP, - , , ProductMaster, ProductVendor VendorMaster. , . , , , . - .
, , . . , . , , , , , , . , , , .
|
|
, , :
CREATE TABLE wide_tbl(a int PRIMARY KEY, b int,..., z int)
CREATE VIEW v_abc WITH SCHEMABINDING AS
SELECT a, b, c
FROM dbo.wide_tbl
WHERE a BETWEEN 0 AND 1000
CREATE UNIQUE CLUSTERED INDEX i_abc ON v_abc(a)
, v_abc:
SELECT b, count_big(*), SUM(c)FROM wide_tbl WHERE a BETWEEN 0 AND 1000GROUP BY b v_abc , wide_tbl. , , , , .
, , , , INCLUDE.
:
- OLTP, .
- .
- , .
- GROUP BY. , , . , . , . , , .
, , 1 000 :
SELECT PriKey, SUM(SalesCol)FROM ExampleTableGROUP BY PriKey100, , , 100 . . , 1000 1 000 . , .
- . , .