- 论坛徽章:
- 0
|
我们公司的应用中,有一张表,其中包括8个txt字段。bcp出来的数据是几百兆,bcp in后,空间占了50GB。想请教各位大哥有无好的办法解决。应用环境:ASE15.0.2 AIX5.3。具体情况如下
1> use zjszyy
2> go
1> sp_help mzyskfk
2> go
Name Owner Object_type Create_date
------- ----- ----------- -------------------
mzyskfk dbo user table Dec 28 2002 12:36PM
(1 row affected)
Column_name Type Length Prec Scale Nulls Default_name Rule_name
Access_Rule_name Computed_Column_object Identity
----------- -------- ------ ---- ----- ----- ------------ ---------
---------------- ---------------------- ----------
id int 4 NULL NULL 0 NULL NULL
NULL NULL 0
zyh int 4 NULL NULL 1 NULL NULL
NULL NULL 0
ysh char 4 NULL NULL 1 NULL NULL
NULL NULL 0
mzkb varchar 5 NULL NULL 1 NULL NULL
NULL NULL 0
mzrq datetime 8 NULL NULL 0 NULL NULL
NULL NULL 0
je numeric 5 8 2 1 NULL NULL
NULL NULL 0
brzz text 16 NULL NULL 1 NULL NULL
NULL NULL 0
xyzs numeric 2 2 0 1 NULL NULL
NULL NULL 0
cyzs numeric 2 2 0 1 NULL NULL
NULL NULL 0
zyzs numeric 2 2 0 1 NULL NULL
NULL NULL 0
bz_zg text 16 NULL NULL 1 NULL NULL
NULL NULL 0
bz_kg text 16 NULL NULL 1 NULL NULL
NULL NULL 0
bazdh_1 varchar 5 NULL NULL 1 NULL NULL
NULL NULL 0
bazdh_2 varchar 5 NULL NULL 1 NULL NULL
NULL NULL 0
bazdh_3 varchar 5 NULL NULL 1 NULL NULL
NULL NULL 0
bazd_1 varchar 40 NULL NULL 1 NULL NULL
NULL NULL 0
bazd_2 varchar 40 NULL NULL 1 NULL NULL
NULL NULL 0
bzzd_3 varchar 40 NULL NULL 1 NULL NULL
NULL NULL 0
sfbz char 1 NULL NULL 1 NULL NULL
NULL NULL 0
bl_zs text 16 NULL NULL 1 NULL NULL
NULL NULL 0
bl_xbs text 16 NULL NULL 1 NULL NULL
NULL NULL 0
bl_jws text 16 NULL NULL 1 NULL NULL
NULL NULL 0
bl_grs text 16 NULL NULL 1 NULL NULL
NULL NULL 0
bl_jts text 16 NULL NULL 1 NULL NULL
NULL NULL 0
bl_tj text 16 NULL NULL 1 NULL NULL
NULL NULL 0
bkbz int 4 NULL NULL 1 NULL NULL
NULL NULL 0
jbm varchar 50 NULL NULL 1 NULL NULL
NULL NULL 0
czgh varchar 5 NULL NULL 1 NULL NULL
NULL NULL 0
mzlx_id tinyint 1 NULL NULL 1 NULL NULL
NULL NULL 0
cz char 1 NULL NULL 1 NULL NULL
NULL NULL 0
xy varchar 20 NULL NULL 1 NULL NULL
NULL NULL 0
dsqs char 1 NULL NULL 1 NULL NULL
NULL NULL 0
scbz char 1 NULL NULL 1 NULL NULL
NULL NULL 0
qx char 1 NULL NULL 1 NULL NULL
NULL NULL 0
dtsz char 1 NULL NULL 1 NULL NULL
NULL NULL 0
bjgb_bz char 1 NULL NULL 1 NULL NULL
NULL NULL 0
Object has the following indexes
index_name index_keys index_description index_max_rows_per_page
index_fillfactor index_reservepagegap index_created index_local
--------------- ---------- ----------------- -----------------------
---------------- -------------------- ------------------- ------------
mzyskfk_x id clustered, unique 0
0 0 Dec 28 2002 4:07PM Global Index
mzyskfk_i_mzrq mzrq nonclustered 0
0 0 Jul 30 2006 4:36AM Global Index
idx_mzyskfk_zyh zyh nonclustered 0
0 0 Jul 30 2006 4:36AM Global Index
(3 rows affected)
index_ptn_name index_ptn_seg
------------------------- -------------
mzyskfk_x_731914698 default
mzyskfk_i_mzrq_731914698 default
idx_mzyskfk_zyh_731914698 default
(3 rows affected)
No defined keys for this object.
name type partition_type partitions partition_keys
------- ---------- -------------- ---------- --------------
mzyskfk base table roundrobin 1 NULL
(1 row affected)
partition_name partition_id pages row_count segment create_date
----------------- ------------ ------ --------- ------- -------------------
mzyskfk_731914698 731914698 456552 4648789 default Aug 15 2008 11:04PM
Partition_Conditions
--------------------
NULL
Avg_pages Max_pages Min_pages Ratio(Max/Avg) Ratio(Min/Avg)
----------- ----------- ----------- -------------------- --------------------
456552 456552 456552 1.000000 1.000000
Lock scheme Allpages
The attribute 'exp_row_size' is not applicable to tables with allpages lock
scheme.
The attribute 'concurrency_opt_threshold' is not applicable to tables with
allpages lock scheme.
exp_row_size reservepagegap fillfactor max_rows_per_page identity_gap
ascinserts
------------ -------------- ---------- ----------------- ------------
-----------
0 0 0 0 0
0
(1 row affected)
concurrency_opt_threshold optimistic_index_lock dealloc_first_txtpg
------------------------- --------------------- -------------------
0 0 0
(return status = 0)
1> sp_spaceused mzyskfk,1
2> go
index_name size reserved unused
--------------- ---------- ---------- ---------
mzyskfk_i_mzrq 114054 KB 114144 KB 90 KB
idx_mzyskfk_zyh 114732 KB 286904 KB 172172 KB
tmzyskfk 53856722 K 54024240 K 167518 KB
mzyskfk_x 8300 KB 927012 KB 5608 KB
(1 row affected)
name rowtotal reserved data index_size unused
------- -------- ----------- --------- ----------- ---------
mzyskfk 4648796 55352300 KB 913104 KB 54093808 KB 345388 KB
(return status = 0)
1> |
|