http://200yi.com/ff_internal/ 2026-04-28T02:53:38+0800 http://200yi.com/ff_internal/ http://200yi.com/ff_internal/lib/tpl/mnml-blog/images/favicon.ico text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:SQLServer:%E6%B5%8B%E8%AF%95:SQLServer%20TPC-H%E6%B5%8B%E8%AF%95&rev=1687008318&do=diff 300s HDD加载时间 load大约8小时。 300s HDD执行时间 Case Time(s) Comment :---: ------: ------- 1 27.3 2 2.7 3 42.6 4 5.9 5 59.4 6 0.9 text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:SQLServer:%E6%B5%8B%E8%AF%95:SQLServer%E5%88%97%E5%AD%98%E5%82%A8TPC-H%E6%B5%8B%E8%AF%95%E6%96%B9%E6%B3%95&rev=1687008318&do=diff TPC-H 300s建表语句 使用列存储： drop database if exists tpch300s; go create database tpch300s; go use tpch300s; create table part( p_partkey bigint not null, p_name varchar(55) not null, p_mfgr char(25) not null, p_brand char(10) not null, p_type varchar(25) not null, p_size bigint not null, p_container char(10) not null, p_retailprice decimal(15,2) not null, p_comment varchar(23) null ); create clustered columnstore index idx_part on part; create table supplier( s_su…