Fragmentation
Posted in 2003
Hi,
We have a huge reporting table. We plan to fragment it into 6
dbspaces
( 84/6 gb in each ).
Table structure -
create table "e50kadm".rep_data
(
date_upload date,
entity char(6),
ctry_cd char(2),
adr_curr char(3),
maj_accnt_cd char(3),
maj_accnt_desc char(27),
accnt_no char(9),
adr_dr_name char(40),
adr_cr_anal char(8),
adr_cr_anal_name char(40),
adr_sal_ter char(3),
salesman_name char(27),
adr_cr_limit decimal(11,2),
adr_adr_acct_bal decimal(15,2),
adr_os_bal decimal(15,2),
adr_current decimal(15,2),
adr_30 decimal(15,2),
adr_60 decimal(15,2),
adr_90 decimal(15,2),
adr_120 decimal(15,2),
adr_150 decimal(15,2),
adr_180 decimal(15,2),
adr_360 decimal(15,2),
adr_dos decimal(15,2),
eur_dos decimal(15,2),
cust_type char(1),
pay_terms char(3),
bad_debt decimal(15,2),
xrate decimal(15,8),
over_terms decimal(15,2),
grp_tot decimal(15,2),
over_limit decimal(15,2),
yr smallint,
week smallint
);
revoke all on "e50kadm".rep_data from "public";
create index "e50kadm".cust_1 on "e50kadm".rep_data (date_upload,
entity,ctry_cd) using btree ;
create index "e50kadm".rep_date_idx2 on "e50kadm".rep_data (date_upload,
maj_accnt_cd) using btree ;
==================================
We plan to fragment by date_upload ( 4 months data in each dbspace )
Want to know should I fragment the indexes? If so, on same criteria or
not?
How can i check whether my indexes are fragmented or not? ( will
dbschema -ss tell me ?)
Rgds
Preetinder