 |
IDS Forum
Re: queries slow after migration
Posted By: Art Kagel
Date: Thursday, 26 May 2011, at 4:21 p.m.
In Response To: Re: queries slow after migration (ROGER VILCA)
It DOES look like you are doing the update stats correctly, but the
difference between the estimate and actual row counts is saying rather
loudly that something is not right. Hmm, Don't remember, is this 11.70? If
so, the AUTOSTATS may be preventing the update statistics commands from
actually doing anything. If this is 11.70, try running those statements
again, but add the FORCE clause to each and see if that helps.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Thu, May 26, 2011 at 3:57 PM, ROGER VILCA <rvilca@luzdelsur.com.pe>wrote:
> I run the statistics according to the guides (I think so). Please, if there
> is
> any addicional recommendation, thanks.
>
> *********** proyectos_de_inver **************
>
> create table "xsic".proyectos_de_inver
> (
>
> empresa char(2) not null ,
>
> folio_proyecto decimal(10,0),
>
> proyecto_inversion char(6) not null ,
>
> descripcion char(100) not null ,
>
> observacion char(255),
>
> item char(4) not null ,
>
> grupo char(1) not null ,
>
> subgrupo char(3),
>
> jefe_proyecto char(50) not null ,
>
> area_gestora char(10),
>
> area_admin char(10),
>
> ano_lib_ppto decimal(4,0) not null ,
>
> fecha_inicio_prog date not null ,
>
> fecha_termino_prog date not null ,
>
> fecha_inicio_real date,
>
> fecha_cierre_real date,
>
> presupuesto_pi_us decimal(12,2),
>
> presupuesto_pi_p decimal(17,2) not null ,
>
> ano_moned_ppto_p decimal(4,0),
>
> mes_moned_ppto_p decimal(2,0),
>
> estado char(1) not null ,
>
> tasa_cambio decimal(10,4),
>
> usuario_actualiz char(30) not null ,
>
> fecha_actualiz date not null ,
>
> rol_dig char(10),
>
> fec_dig date,
>
> rol_aut char(10),
>
> fec_aut date,
>
> rol_apr char(10),
>
> fec_apr date,
>
> rol_act char(10),
>
> tipo_proy char(10),
>
> indppto char(1)
>
> default 'S'
> );
>
> revoke all on "xsic".proyectos_de_inver from "public" as "xsic";
>
> create index "xsic".i_ep_proy_inver on "xsic".proyectos_de_inver
>
> (proyecto_inversion,empresa) using btree ;
> create index "xsic".proyecto on "xsic".proyectos_de_inver
> (proyecto_inversion,
>
> ano_lib_ppto,empresa) using btree ;
>
> DATABASE sifco;
> SET PDQPRIORITY 0;
> UPDATE STATISTICS MEDIUM FOR TABLE proyectos_de_inver DISTRIBUTIONS ONLY;
> UPDATE STATISTICS HIGH FOR TABLE proyectos_de_inver (proyecto_inversion)
> DISTRIBUTIONS ONLY;
> UPDATE STATISTICS LOW FOR TABLE proyectos_de_inver (proyecto_inversion,
> empresa);
> UPDATE STATISTICS HIGH FOR TABLE proyectos_de_inver ( ano_lib_ppto )
> DISTRIBUTIONS ONLY;
> UPDATE STATISTICS HIGH FOR TABLE proyectos_de_inver ( empresa)
> DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE proyectos_de_inver (proyecto_inversion,
> ano_lib_ppto, empresa);
>
> *********** inver_de_capital ****************
>
> create table "xsic".inver_de_capital
> (
>
> empresa char(2) not null ,
>
> inversion_capital char(6) not null ,
>
> descripcion char(50),
>
> observacion char(255),
>
> responasable char(50),
>
> jefe_proyecto char(50) not null ,
>
> area_ejecutora char(10),
>
> fecha_inicio_prog date not null ,
>
> fecha_termino_prog date not null ,
>
> fecha_inicio_real date,
>
> fecha_puesta_serv date,
>
> fecha_cierre_real date,
>
> presupuesto_tot_ic decimal(17,2) not null ,
>
> presupuesto_tot_us decimal(17,2) not null ,
>
> ano_moned_ppto decimal(4,0) not null ,
>
> mes_moned_ppto decimal(2,0) not null ,
>
> proyecto_inver char(6),
>
> estado char(1) not null ,
>
> usuario_actualiz char(30),
>
> fecha_actualiz date,
>
> correl_registro char(10),
>
> area_gestora char(10),
>
> actividad char(10),
>
> usr_reg char(12),
>
> fec_reg date,
>
> usr_apr char(12),
>
> fec_apr date,
>
> usr_aut char(12),
>
> fec_aut date,
>
> usr_cie char(12),
>
> fec_cie date,
>
> rol_reg char(12),
>
> rol_aut char(12),
>
> rol_apr char(12),
>
> rol_cie char(12),
>
> rol_rec_apr char(12),
>
> rol_rec_aut char(12),
>
> fec_rec_apr date,
>
> fec_rec_aut date,
>
> glosa_cierre varchar(20),
>
> indexceso char(1)
>
> default 'N' not null ,
>
> pctexceso smallint
>
> default 0 not null ,
>
> version char(1)
>
> default ''
> );
>
> revoke all on "xsic".inver_de_capital from "public" as "xsic";
>
> create index "xsic".idx_correl on "xsic".inver_de_capital (correl_registro,
>
> empresa) using btree ;
> create index "xsic".inversion_capital on "xsic".inver_de_capital
>
> (inversion_capital,empresa) using btree ;
> create index "xsic".proyecto_inver on "xsic".inver_de_capital
>
> (proyecto_inver,empresa) using btree ;
>
> DATABASE sifco;
> SET PDQPRIORITY 0;
> UPDATE STATISTICS MEDIUM FOR TABLE inver_de_capital DISTRIBUTIONS ONLY;
> UPDATE STATISTICS HIGH FOR TABLE inver_de_capital (inversion_capital)
> DISTRIBUTIONS ONLY;
> UPDATE STATISTICS LOW FOR TABLE inver_de_capital (inversion_capital,
> empresa);
> UPDATE STATISTICS HIGH FOR TABLE inver_de_capital (proyecto_inver)
> DISTRIBUTIONS ONLY;
> UPDATE STATISTICS LOW FOR TABLE inver_de_capital (proyecto_inver, empresa);
> UPDATE STATISTICS HIGH FOR TABLE inver_de_capital (correl_registro)
> DISTRIBUTIONS ONLY;
> UPDATE STATISTICS LOW FOR TABLE inver_de_capital (correl_registro,
> empresa);
>
> *********** con_combin ***********************
>
> create table "xsic".con_combin
> (
>
> empresa char(10) not null ,
>
> combinatoria decimal(8,0) not null ,
>
> aux_valor1 char(10),
>
> aux_valor2 char(10),
>
> aux_valor3 char(10),
>
> aux_valor4 char(10),
>
> aux_valor5 char(10),
>
> aux_valor6 char(10),
>
> aux_valor7 char(10),
>
> aux_valor8 char(10),
>
> aux_valor9 char(10),
>
> aux_valor10 char(10),
>
> aux_valor11 char(10),
>
> aux_valor12 char(20),
>
> aux_valor13 char(10),
>
> aux_valor14 char(10),
>
> aux_valor15 char(10),
>
> aux_valor16 char(10),
>
> aux_valor17 char(10),
>
> aux_valor18 char(10),
>
> aux_valor19 char(10),
>
> aux_valor20 char(10)
> );
>
> revoke all on "xsic".con_combin from "public" as "xsic";
>
> create index "xsic".i1_con_combin on "xsic".con_combin (aux_valor1,
>
> empresa) using btree ;
> create index "xsic".i10_con_combin on "xsic".con_combin (aux_valor10,
>
> empresa) using btree ;
> create unique index "xsic".i100_con_combin on "xsic".con_combin
>
> (combinatoria,empresa) using btree ;
> create index "xsic".i11_con_combin on "xsic".con_combin (aux_valor11,
>
> empresa) using btree ;
> create index "xsic".i12_con_combin on "xsic".con_combin (aux_valor12,
>
> empresa) using btree ;
> create index "xsic".i13_con_combin on "xsic".con_combin (aux_valor13,
>
> empresa) using btree ;
> create index "xsic".i14_con_combin on "xsic".con_combin (aux_valor14,
>
> empresa) using btree ;
> create index "xsic".i15_con_combin on "xsic".con_combin (aux_valor15,
>
> empresa) using btree ;
> create index "xsic".i16_con_combin on "xsic".con_combin (aux_valor16,
>
> empresa) using btree ;
> create index "xsic".i2_con_combin on "xsic".con_combin (aux_valor2,
>
> empresa) using btree ;
> create index "xsic".i3_con_combin on "xsic".con_combin (aux_valor3,
>
> empresa) using btree ;
> create index "xsic".i4_con_combin on "xsic".con_combin (aux_valor4,
>
> empresa) using btree ;
> create index "xsic".i5_con_combin on "xsic".con_combin (aux_valor5,
>
> empresa) using btree ;
> create index "xsic".i6_con_combin on "xsic".con_combin (aux_valor6,
>
> empresa) using btree ;
> create index "xsic".i7_con_combin on "xsic".con_combin (aux_valor7,
>
> empresa) using btree ;
> create index "xsic".i8_con_combin on "xsic".con_combin (aux_valor8,
>
> empresa) using btree ;
> create index "xsic".i9_con_combin on "xsic".con_combin (aux_valor9,
>
> empresa) using btree ;
> create index "xsic".idx_act_cr_rec on "xsic".con_combin (aux_valor4,
>
> aux_valor5,aux_valor9,combinatoria,empresa) using btree ;
>
> create index "xsic".integra on "xsic".con_combin (aux_valor1,aux_valor2,
>
> aux_valor3,aux_valor4,aux_valor5,aux_valor6,aux_valor7,aux_valor8,
>
> aux_valor9,aux_valor10,aux_valor11,aux_valor12,aux_valor13,
>
> aux_valor14,aux_valor15,aux_valor16) using btree ;
>
> DATABASE sifco;
> SET PDQPRIORITY 0;
> UPDATE STATISTICS MEDIUM FOR TABLE con_combin DISTRIBUTIONS ONLY;
> UPDATE STATISTICS HIGH FOR TABLE con_combin (combinatoria) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_combin (combinatoria, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_combin (aux_valor1) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_combin (aux_valor1, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_combin ( aux_valor2 ) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS HIGH FOR TABLE con_combin ( empresa) DISTRIBUTIONS ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_combin (aux_valor1, aux_valor2,
> aux_valor3, aux_valor4, aux_valor5, aux_valor6, aux_valor7, aux_valor8,
> aux_valor9, aux_valor10, aux_valor11, aux_valor12, aux_valor13,
> aux_valor14,
> aux_valor15, aux_valor16);
> UPDATE STATISTICS LOW FOR TABLE con_combin (aux_valor2, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_combin (aux_valor3) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_combin (aux_valor3, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_combin (aux_valor4) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_combin (aux_valor4, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_combin ( aux_valor5 ) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_combin (aux_valor4, aux_valor5,
> aux_valor9, combinatoria, empresa);
> UPDATE STATISTICS LOW FOR TABLE con_combin (aux_valor5, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_combin (aux_valor6) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_combin (aux_valor6, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_combin (aux_valor7) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_combin (aux_valor7, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_combin (aux_valor8) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_combin (aux_valor8, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_combin (aux_valor9) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_combin (aux_valor9, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_combin (aux_valor10) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_combin (aux_valor10, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_combin (aux_valor11) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_combin (aux_valor11, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_combin (aux_valor12) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_combin (aux_valor12, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_combin (aux_valor13) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_combin (aux_valor13, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_combin (aux_valor14) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_combin (aux_valor14, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_combin (aux_valor15) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_combin (aux_valor15, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_combin (aux_valor16) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_combin (aux_valor16, empresa);
>
> *********** con_enccom ***********************
>
> create table "xsic".con_enccom
> (
>
> empresa char(10) not null ,
>
> ano decimal(4,0) not null ,
>
> mes decimal(2,0) not null ,
>
> dia decimal(2,0) not null ,
>
> tipo_comprobante char(10) not null ,
>
> correlativo char(10) not null ,
>
> fecha date not null ,
>
> glosa char(255),
>
> numero_externo decimal(8,0),
>
> moneda char(10) not null ,
>
> tasa decimal(13,4) not null ,
>
> origen char(10) not null ,
>
> total decimal(16,2),
>
> estado char(1) not null ,
>
> usuario char(40),
>
> fecha_modificacion date,
>
> fecha_creacion date,
>
> terminal char(30),
>
> ind_cierre decimal(2,0)
>
> default 0,
>
> tip_origen char(1),
>
> rol_int char(10),
>
> fec_int date,
>
> rol_of char(10),
>
> fec_of date,
>
> total_me decimal(16,2),
>
> ind_conversion char(1)
>
> default 'S',
>
> tipo_ajuste char(10),
>
> ind_acumulable char(1)
>
> default 'S',
>
> ano_origen decimal(4,0),
>
> mes_origen decimal(2,0)
> );
>
> revoke all on "xsic".con_enccom from "public" as "xsic";
>
> create unique index "xsic".i1_con_enccom on "xsic".con_enccom
>
> (correlativo,tipo_comprobante,empresa) using btree ;
> create unique index "xsic".i2_con_enccom on "xsic".con_enccom
>
> (correlativo,numero_externo,tipo_comprobante,fecha,empresa)
>
> using btree ;
> create index "xsic".i3_con_enccom on "xsic".con_enccom (mes,ano,
>
> empresa) using btree ;
> create index "xsic".i4_con_enccom on "xsic".con_enccom (estado,
>
> tipo_comprobante,correlativo,empresa) using btree ;
> create index "xsic".i5_con_enccom on "xsic".con_enccom (fecha,
>
> correlativo,tipo_comprobante,empresa) using btree ;
> create index "xsic".i6_con_enccom on "xsic".con_enccom (correlativo,
>
> tipo_comprobante,ano,empresa) using btree ;
>
> alter table "xsic".con_enccom add constraint (foreign key
> (tipo_comprobante,
>
> empresa) references "xsic".con_comprob );
>
> DATABASE sifco;
> SET PDQPRIORITY 0;
> UPDATE STATISTICS MEDIUM FOR TABLE con_enccom DISTRIBUTIONS ONLY;
> UPDATE STATISTICS HIGH FOR TABLE con_enccom (mes) DISTRIBUTIONS ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_enccom (mes, ano, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_enccom (tipo_comprobante)
> DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_enccom (tipo_comprobante, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_enccom (correlativo) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_enccom (correlativo, tipo_comprobante,
> empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_enccom ( ano ) DISTRIBUTIONS ONLY;
> UPDATE STATISTICS HIGH FOR TABLE con_enccom ( empresa) DISTRIBUTIONS ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_enccom (correlativo, tipo_comprobante,
> ano, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_enccom ( numero_externo )
> DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_enccom (correlativo, numero_externo,
> tipo_comprobante, fecha, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_enccom (fecha) DISTRIBUTIONS ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_enccom (fecha, correlativo,
> tipo_comprobante, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_enccom (estado) DISTRIBUTIONS ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_enccom (estado, tipo_comprobante,
> correlativo, empresa);
>
> *********** con_movcom ***********************
>
> create table "xsic".con_movcom
> (
>
> empresa char(10) not null ,
>
> ano decimal(4,0) not null ,
>
> mes decimal(2,0) not null ,
>
> dia decimal(2,0) not null ,
>
> fecha date not null ,
>
> tipo_comprobante char(10) not null ,
>
> correlativo char(10) not null ,
>
> secuencia decimal(5,0) not null ,
>
> cuenta char(12) not null ,
>
> ord_serie decimal(3,0),
>
> referencia char(20),
>
> origen char(10) not null ,
>
> estado char(1) not null ,
>
> debe_ingreso decimal(16,2),
>
> haber_ingreso decimal(16,2),
>
> debe_origen decimal(16,2),
>
> haber_origen decimal(16,2),
>
> debe_cuota decimal(13,4),
>
> haber_cuota decimal(13,4),
>
> tasa_cuota decimal(13,4),
>
> glosa char(100),
>
> calce_analisis char(1),
>
> calce_banco decimal(8,0),
>
> combinatoria decimal(8,0),
>
> tipo_documento char(10),
>
> correl_calce char(10)
>
> default '',
>
> fecha_calce date,
>
> ind_calce_temp char(1),
>
> descripcion char(30),
>
> debe_mn decimal(16,2)
>
> default 0.00,
>
> haber_mn decimal(16,2)
>
> default 0.00,
>
> moneda_original char(10),
>
> debe_mn_a_me decimal(16,2)
>
> default 0.00,
>
> haber_mn_a_me decimal(16,2)
>
> default 0.00,
>
> debe_me decimal(16,2)
>
> default 0.00,
>
> haber_me decimal(16,2)
>
> default 0.00,
>
> debe_tot_me decimal(16,2)
>
> default 0.00,
>
> haber_tot_me decimal(16,2)
>
> default 0.00,
>
> ind_mov_acm char(1),
>
> fecha_mov date,
>
> folio_interno decimal(10,0),
>
> nro_solicitud char(7)
> );
>
> revoke all on "xsic".con_movcom from "public" as "xsic";
>
> create index "xsic".cuenta_comprobante on "xsic".con_movcom (cuenta,
>
> fecha,correlativo,tipo_comprobante,empresa) using btree ;
>
> create index "xsic".i11_con_movcom on "xsic".con_movcom (cuenta,
>
> correl_calce,empresa) using btree ;
> create index "xsic".i12_con_movcom on "xsic".con_movcom (correl_calce,
>
> cuenta,empresa) using btree ;
> create index "xsic".i2_con_movcom on "xsic".con_movcom (combinatoria,
>
> empresa) using btree ;
> create index "xsic".i3_con_movcom on "xsic".con_movcom (correlativo,
>
> tipo_comprobante,fecha,ano,cuenta,origen,combinatoria,empresa)
>
> using btree ;
> create index "xsic".i4_con_movcom on "xsic".con_movcom (cuenta,
>
> referencia,calce_analisis,estado,combinatoria,empresa) using
>
> btree ;
> create index "xsic".i5_con_movcom on "xsic".con_movcom (fecha,
>
> ano,estado,cuenta,empresa) using btree ;
> create index "xsic".i8_con_movcom on "xsic".con_movcom (cuenta,
>
> mes,ano,empresa,correlativo) using btree ;
> create index "xsic".idx_analisis_prv on "xsic".con_movcom (cuenta,
>
> referencia,fecha,empresa,correl_calce) using btree ;
> create index "xsic".idx_cuentafecha on "xsic".con_movcom (cuenta,
>
> fecha,correl_calce,empresa) using btree ;
> create index "xsic".idx_movfec2 on "xsic".con_movcom (cuenta,fecha_calce,
>
> correl_calce,empresa) using btree ;
> create index "xsic".ind1_con_movcom on "xsic".con_movcom (cuenta,
>
> combinatoria) using btree ;
> create index "xsic".ind7_con_movcom on "xsic".con_movcom (correlativo,
>
> tipo_comprobante,cuenta,combinatoria) using btree ;
> create index "xsic".ind9_con_movcom on "xsic".con_movcom (cuenta,
>
> origen,mes,ano,empresa) using btree ;
> create index "xsic".ipru_con_movcom on "xsic".con_movcom (ano,
>
> mes,cuenta,empresa) using btree ;
>
> DATABASE sifco;
> SET PDQPRIORITY 0;
> UPDATE STATISTICS MEDIUM FOR TABLE con_movcom DISTRIBUTIONS ONLY;
> UPDATE STATISTICS HIGH FOR TABLE con_movcom (ano) DISTRIBUTIONS ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_movcom (ano, mes, cuenta, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_movcom (fecha) DISTRIBUTIONS ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_movcom (fecha, ano, estado, cuenta,
> empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_movcom (correlativo) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_movcom (correlativo, tipo_comprobante,
> fecha, ano, cuenta, origen, combinatoria, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_movcom ( cuenta ) DISTRIBUTIONS ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_movcom (correlativo, tipo_comprobante,
> cuenta, combinatoria);
> UPDATE STATISTICS LOW FOR TABLE con_movcom (cuenta, mes, ano, empresa,
> correlativo);
> UPDATE STATISTICS HIGH FOR TABLE con_movcom ( mes) DISTRIBUTIONS ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_movcom (cuenta, fecha, correlativo,
> tipo_comprobante, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_movcom ( correl_calce ) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_movcom (cuenta, fecha, correl_calce,
> empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_movcom ( referencia ) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_movcom (cuenta, referencia, fecha,
> empresa, correl_calce);
> UPDATE STATISTICS HIGH FOR TABLE con_movcom ( calce_analisis )
> DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_movcom (cuenta, referencia,
> calce_analisis, estado, combinatoria, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_movcom ( origen ) DISTRIBUTIONS ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_movcom (cuenta, origen, mes, ano,
> empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_movcom ( combinatoria ) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_movcom (cuenta, combinatoria);
> UPDATE STATISTICS LOW FOR TABLE con_movcom (cuenta, correl_calce, empresa);
> UPDATE STATISTICS HIGH FOR TABLE con_movcom ( fecha_calce ) DISTRIBUTIONS
> ONLY;
> UPDATE STATISTICS LOW FOR TABLE con_movcom (cuenta, fecha_calce,
> correl_calce,
> empresa);
> UPDATE STATISTICS LOW FOR TABLE con_movcom (combinatoria, empresa);
> UPDATE STATISTICS LOW FOR TABLE con_movcom (correl_calce, cuenta, empresa);
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--bcaec50166b795aab804a4338fc9
Messages In This Thread
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|
