Ola amigos
qual a melhor forma de otimizar as queries abaixo ( ja consegui alguma
otimizacao, tanto que no final esta os indices extras que criei para essas
queries)
select b.inrcmv, b.inrndc, b.inrpur, a.cnrfor, c.movfor, b.inrcme, a.cnrure,
a.cnrutr, a.cnrdrm, a.cnrnnf, a.cnrenf, d.concpg, a.cnrvnf, b.inrvlr,
a.cnricm, b.inripi, a.cnrpis, a.cnrcofin, b.inrqtg, '' as
romplc, a.cnrbfu, a.cnrvim, a.cnrcf2, c.movpli,
q.flagsit, a.cnrsnf, a.cnrtim, c.movdoc from
qr_dbf_sie3000_log as q join granol_sie3000_dbf as a on q.cnrnum =
a.cnrnum join granol_sie3200_dbf as b on a.cnrnum = b.inrnum
join sif00_con1000_dbf as d on b.inrndc =
d.connum||trim(to_char(d.conuni,'00')) join sif50_mov1000_dbf as c
on b.inrnum = c.movnnr where a.cnrsis = 1 and b.inrdco = 1 and
b.inrcmv in ( 1,4,5,20,29,44,45,49,67,68,70,71,73 ) order by q.cnrnum
LIMIT 1
select b.inrcmv, b.inrndc, b.inrpur, a.cnrfor, d.movfor, b.inrcme, a.cnrure,
a.cnrutr, a.cnrdrm, a.cnrnnf, a.cnrenf, '' as concpg, a.cnrvnf, b.inrvlr,
a.cnricm, b.inripi, a.cnrpis, a.cnrcofin, b.inrqtg, c.romplc, a.cnrbfu,
a.cnrvim, a.cnrcf2, d.movpli, q.flagsit, a.cnrsnf, a.cnrtim, d.movdoc from
qr_dbf_sie3000_log as q join granol_sie3000_dbf as a on q.cnrnum =
a.cnrnum join granol_sie3200_dbf as b on a.cnrnum = b.inrnum join
granol_sie3300_dbf as c on q.cnrnum = c.romnum join sif50_mov1000_dbf as d
on a.cnrcon = d.movcon and a.cnruni = d.movunc and a.cnrnfr =
d.movnpr where ( b.inrdco = 1 or a.cnrlrt >= 70 ) and b.inrcmv in
(21,49,72) and c.romtip = 'D' order by q.cnrnum LIMIT 1
select q.cnrnum, b.inrcmv, b.inrndc, b.inrpur, a.cnrfor, '' as movfor,
b.inrcme, a.cnrure, a.cnrutr, a.cnrdrm, a.cnrnnf, a.cnrenf, '' as concpg,
a.cnrvnf, b.inrvlr, a.cnricm, b.inripi, a.cnrpis, a.cnrcofin, b.inrqtg,
c.romplc, a.cnrbfu, a.cnrvim, a.cnrcf2, '' as movpli, q.flagsit, a.cnrsnf,
a.cnrtim, '' as movdoc from qr_dbf_sie3000_log as q join granol_sie3000_dbf
as a on q.cnrnum = a.cnrnum join granol_sie3200_dbf as b on a.cnrnum =
b.inrnum left join granol_sie3300_dbf as c on q.cnrnum = c.romnum and
c.romtip = 'D' where a.cnrlrt < 70 and b.inrcmv in
(21,22,33,34,40,42,43,47,48,98,99) order by q.cnrnum LIMIT 1
as estruturas e indices estao abaixo
CREATE TABLE qr_dbf_sie3000_log
(
cnrnum char(10) NOT NULL,
flagsit char(1) NOT NULL,
CONSTRAINT qr_dbf_sie3000_log_pkey PRIMARY KEY (cnrnum, flagsit)
)
WITHOUT OIDS;
ALTER TABLE qr_dbf_sie3000_log OWNER TO postgres;
-------------------------
-- Table: granol_sie3000_dbf
-- DROP TABLE granol_sie3000_dbf;
CREATE TABLE granol_sie3000_dbf
(
cnrnum char(10),
cnrqti numeric(2) DEFAULT 0,
cnrrom numeric(2) DEFAULT 0,
cnruft numeric(2) DEFAULT 0,
cnrure numeric(2) DEFAULT 0,
cnrlrt numeric(2) DEFAULT 0,
cnremi date,
cnrfor numeric(5) DEFAULT 0,
cnrnnf numeric(9,2) DEFAULT 0,
cnrtnf numeric(2) DEFAULT 0,
cnrsnf char(3),
cnrenf date,
cnrdrm date,
cnrcf1 numeric(4) DEFAULT 0,
cnrcf2 numeric(4) DEFAULT 0,
cnrppg numeric(2) DEFAULT 0,
cnrcpg numeric(3) DEFAULT 0,
cnrvct date,
cnrvlr numeric(14,2) DEFAULT 0,
cnrfre numeric(14,2) DEFAULT 0,
cnrseg numeric(14,2) DEFAULT 0,
cnrtim numeric(1) DEFAULT 0,
cnrpfr numeric(1) DEFAULT 0,
cnrpim numeric(4,1) DEFAULT 0,
cnrbfu numeric(14,2) DEFAULT 0,
cnrvim numeric(14,2) DEFAULT 0,
cnrpic numeric(4,1) DEFAULT 0,
cnrbic numeric(14,2) DEFAULT 0,
cnricm numeric(14,2) DEFAULT 0,
cnrpde numeric(4,1) DEFAULT 0,
cnrdes numeric(14,2) DEFAULT 0,
cnrmer numeric(14,2) DEFAULT 0,
cnripi numeric(14,2) DEFAULT 0,
cnrvnf numeric(14,2) DEFAULT 0,
cnrcht char(6),
cnrntr varchar(30),
cnrpla char(8),
cnrhap numeric(1) DEFAULT 0,
cnrimp numeric(1) DEFAULT 0,
cnrutr numeric(2) DEFAULT 0,
cnrsis numeric(1) DEFAULT 0,
cnrfis numeric(1) DEFAULT 0,
cnrftc date,
cnrcfp numeric(1) DEFAULT 0,
cnrrtr numeric(1) DEFAULT 0,
cnrsid numeric(1) DEFAULT 0,
cnrtra date,
cnrsos numeric(1) DEFAULT 0,
cnrnfr numeric(14) DEFAULT 0,
cnrctr numeric(7) DEFAULT 0,
cnrnot numeric(5) DEFAULT 0,
cnrdot numeric(1) DEFAULT 0,
cnrfot char(1),
cnrsft numeric(1) DEFAULT 0,
cnrpnf numeric(12,3) DEFAULT 0,
cnrtip numeric(2) DEFAULT 0,
cnrcon numeric(5) DEFAULT 0,
cnruni numeric(2) DEFAULT 0,
cnrdtc date,
cnrist varchar(14),
cnrpin numeric(5,2) DEFAULT 0,
cnrvin numeric(14,2) DEFAULT 0,
cnrapp numeric(6) DEFAULT 0,
cnrbin numeric(14,2) DEFAULT 0,
cnrcsll numeric(14,2) DEFAULT 0,
cnrpis numeric(14,2) DEFAULT 0,
cnrcofin numeric(14,2) DEFAULT 0,
cnrciss numeric(5) DEFAULT 0,
cnrbiss numeric(14,2) DEFAULT 0,
cnraiss numeric(5,2) DEFAULT 0,
cnrviss numeric(14,2) DEFAULT 0,
sr_recno bigserial NOT NULL ,
sr_deleted char(1) NOT NULL DEFAULT ' '::bpchar,
indkey_001 varchar(254),
indkey_002 varchar(254),
indkey_003 varchar(254),
CONSTRAINT granol_sie3000_dbf_sr_recno_key UNIQUE (sr_recno)
)
WITHOUT OIDS;
ALTER TABLE granol_sie3000_dbf OWNER TO postgres;
GRANT ALL ON TABLE granol_sie3000_dbf TO postgres;
-- Index: granol_sie3000_dbf_sr
-- DROP INDEX granol_sie3000_dbf_sr;
CREATE INDEX granol_sie3000_dbf_sr
ON granol_sie3000_dbf
USING btree
(sr_recno);
-- Index: granol_sie300a_000001
-- DROP INDEX granol_sie300a_000001;
CREATE INDEX granol_sie300a_000001
ON granol_sie3000_dbf
USING btree
(indkey_001);
-- Index: granol_sie300b_000002
-- DROP INDEX granol_sie300b_000002;
CREATE INDEX granol_sie300b_000002
ON granol_sie3000_dbf
USING btree
(indkey_002);
-- Index: granol_sie300c_000003
-- DROP INDEX granol_sie300c_000003;
CREATE INDEX granol_sie300c_000003
ON granol_sie3000_dbf
USING btree
(indkey_003);
-- Trigger: tr_qr_sie3000_log on granol_sie3000_dbf
-- DROP TRIGGER tr_qr_sie3000_log ON granol_sie3000_dbf;
-- Table: granol_sie3200_dbf
-- DROP TABLE granol_sie3200_dbf;
CREATE TABLE granol_sie3200_dbf
(
inrnum char(10),
inrite numeric(2) DEFAULT 0,
inrnit numeric(2) DEFAULT 0,
inrtme numeric(1) DEFAULT 0,
inrdco numeric(1) DEFAULT 0,
inrcmv numeric(3) DEFAULT 0,
inrndc numeric(7) DEFAULT 0,
inrcme numeric(6) DEFAULT 0,
inrdig numeric(1) DEFAULT 0,
inrqtg numeric(12,3) DEFAULT 0,
inrqt3 numeric(12,3) DEFAULT 0,
inrunm char(2),
inrun3 char(2),
inrdes varchar(36),
inrpui numeric(17,5) DEFAULT 0,
inrvlr numeric(14,2) DEFAULT 0,
inrpip numeric(5,2) DEFAULT 0,
inripi numeric(14,2) DEFAULT 0,
inrrip numeric(1) DEFAULT 0,
inrric numeric(1) DEFAULT 0,
inrtip numeric(1) DEFAULT 0,
inrtic numeric(1) DEFAULT 0,
inrcmo numeric(3) DEFAULT 0,
inrpur numeric(17,5) DEFAULT 0,
inrnfo numeric(9,2) DEFAULT 0,
inricm numeric(14,2) DEFAULT 0,
inruos numeric(2) DEFAULT 0,
inrcct char(5),
inrcdb numeric(5) DEFAULT 0,
inrcre numeric(5) DEFAULT 0,
inrvcd numeric(14,2) DEFAULT 0,
inrfre numeric(14,2) DEFAULT 0,
inrseg numeric(14,2) DEFAULT 0,
inrdct numeric(14,2) DEFAULT 0,
inrtra date,
inrome numeric(1) DEFAULT 0,
inrctb numeric(2) DEFAULT 0,
inrics numeric(14,2) DEFAULT 0,
inrbst numeric(17,2) DEFAULT 0,
inrpli numeric(12,3) DEFAULT 0,
inritc numeric(2) DEFAULT 0,
sr_recno bigserial NOT NULL DEFAULT ,
sr_deleted char(1) NOT NULL DEFAULT ' '::bpchar,
indkey_001 varchar(254),
indkey_002 varchar(254),
CONSTRAINT granol_sie3200_dbf_sr_recno_key UNIQUE (sr_recno)
)
WITHOUT OIDS;
ALTER TABLE granol_sie3200_dbf OWNER TO postgres;
-- Index: granol_sie3200_dbf_sr
-- DROP INDEX granol_sie3200_dbf_sr;
CREATE INDEX granol_sie3200_dbf_sr
ON granol_sie3200_dbf
USING btree
(sr_recno);
-- Index: granol_sie320a_000001
-- DROP INDEX granol_sie320a_000001;
CREATE INDEX granol_sie320a_000001
ON granol_sie3200_dbf
USING btree
(indkey_001);
-- Index: granol_sie320b_000002
-- DROP INDEX granol_sie320b_000002;
CREATE INDEX granol_sie320b_000002
ON granol_sie3200_dbf
USING btree
(indkey_002);
------------------------
-- Table: sif00_con1000_dbf
-- DROP TABLE sif00_con1000_dbf;
CREATE TABLE sif00_con1000_dbf
(
connum numeric(5) DEFAULT 0,
conuni numeric(2) DEFAULT 0,
condat date,
concat numeric(1) DEFAULT 0,
conpen numeric(1) DEFAULT 0,
conden date,
concen numeric(1) DEFAULT 0,
confre numeric(13,4) DEFAULT 0,
condes numeric(1) DEFAULT 0,
conude numeric(2) DEFAULT 0,
condpg date,
conppg numeric(2) DEFAULT 0,
concpg numeric(1) DEFAULT 0,
conpfi date,
condtf date,
concor numeric(1) DEFAULT 0,
conval numeric(15,2) DEFAULT 0,
confor numeric(5) DEFAULT 0,
confct numeric(1) DEFAULT 0,
confun numeric(1) DEFAULT 0,
concme numeric(6) DEFAULT 0,
conunc char(2),
consaf numeric(1) DEFAULT 0,
conicm numeric(2) DEFAULT 0,
conqta numeric(14,3) DEFAULT 0,
convlu numeric(11,4) DEFAULT 0,
conumi numeric(5,2) DEFAULT 0,
conimp numeric(5,2) DEFAULT 0,
conard numeric(5,2) DEFAULT 0,
conaci numeric(5,2) DEFAULT 0,
consab numeric(5,2) DEFAULT 0,
conver numeric(4,1) DEFAULT 0,
conama numeric(4,1) DEFAULT 0,
conazu numeric(4,1) DEFAULT 0,
conob1 varchar(50),
conob2 varchar(50),
conob3 varchar(50),
conob4 varchar(50),
conuff numeric(2) DEFAULT 0,
consit numeric(1) DEFAULT 0,
contra date,
contxj numeric(5,2) DEFAULT 0,
conpco numeric(5,2) DEFAULT 0,
conuco numeric(2) DEFAULT 0,
connci numeric(5) DEFAULT 0,
conuci numeric(2) DEFAULT 0,
conncp numeric(5) DEFAULT 0,
conucp numeric(2) DEFAULT 0,
conqut char(3),
conudd char(8),
convpa char(1),
conban numeric(3) DEFAULT 0,
conage numeric(4) DEFAULT 0,
concon varchar(15),
condol numeric(7,2) DEFAULT 0,
concla text,
consfr char(5),
conemb numeric(1) DEFAULT 0,
conpes numeric(1) DEFAULT 0,
contpi numeric(1) DEFAULT 0,
conot1 numeric(5) DEFAULT 0,
conot2 numeric(5) DEFAULT 0,
conot3 numeric(5) DEFAULT 0,
concom numeric(5,2) DEFAULT 0,
conde1 date,
conend varchar(50),
concpa varchar(50),
concrt numeric(11,4) DEFAULT 0,
conarm numeric(11,4) DEFAULT 0,
conofe numeric(7) DEFAULT 0,
conuof numeric(2) DEFAULT 0,
condof date,
congmof char(1),
condesca char(10),
condescv numeric(15,5) DEFAULT 0,
conguia char(1),
consitu char(1),
conroya1 char(1),
conroya2 char(1),
sr_recno bigserial NOT NULL ,
sr_deleted char(1) NOT NULL DEFAULT ' '::bpchar,
CONSTRAINT sif00_con1000_dbf_sr_recno_key UNIQUE (sr_recno)
)
WITHOUT OIDS;
ALTER TABLE sif00_con1000_dbf OWNER TO postgres;
-- Index: jka50919_000001
-- DROP INDEX jka50919_000001;
CREATE INDEX jka50919_000001
ON sif00_con1000_dbf
USING btree
(confor, sr_recno);
-- Index: sif00_con1000_dbf_sr
-- DROP INDEX sif00_con1000_dbf_sr;
CREATE INDEX sif00_con1000_dbf_sr
ON sif00_con1000_dbf
USING btree
(sr_recno);
-- Index: sif00_con100a_000002
-- DROP INDEX sif00_con100a_000002;
CREATE INDEX sif00_con100a_000002
ON sif00_con1000_dbf
USING btree
(connum, conuni, sr_recno);
-- Index: sif00_con100b_000003
-- DROP INDEX sif00_con100b_000003;
CREATE INDEX sif00_con100b_000003
ON sif00_con1000_dbf
USING btree
(conncp, conucp, sr_recno);
-- Index: sif00_con100c_000004
-- DROP INDEX sif00_con100c_000004;
CREATE INDEX sif00_con100c_000004
ON sif00_con1000_dbf
USING btree
(confor, sr_recno);
-- Index: sif00_con100d_000005
-- DROP INDEX sif00_con100d_000005;
CREATE INDEX sif00_con100d_000005
ON sif00_con1000_dbf
USING btree
(conuof, conofe, condof, sr_recno);
-- Index: sit00_coni101_000006
-- DROP INDEX sit00_coni101_000006;
CREATE INDEX sit00_coni101_000006
ON sif00_con1000_dbf
USING btree
(confor, sr_recno);
-----------------------
-- Table: granol_sie3300_dbf
-- DROP TABLE granol_sie3300_dbf;
CREATE TABLE granol_sie3300_dbf
(
romnum char(10),
romite numeric(2) DEFAULT 0,
romtip char(1),
romuor numeric(2) DEFAULT 0,
romtic numeric(6) DEFAULT 0,
rombrv numeric(6) DEFAULT 0,
romtar numeric(6) DEFAULT 0,
romqts numeric(4) DEFAULT 0,
romtas numeric(4) DEFAULT 0,
romren numeric(8,2) DEFAULT 0,
romimp numeric(5,2) DEFAULT 0,
romaci numeric(5,2) DEFAULT 0,
romumi numeric(5,2) DEFAULT 0,
romard numeric(5,2) DEFAULT 0,
romcf1 numeric(5) DEFAULT 0,
romcf2 numeric(5) DEFAULT 0,
romcf3 numeric(5) DEFAULT 0,
romcf4 numeric(5) DEFAULT 0,
romct1 numeric(6) DEFAULT 0,
romct2 numeric(6) DEFAULT 0,
romct3 numeric(6) DEFAULT 0,
romct4 numeric(6) DEFAULT 0,
romsd1 numeric(4) DEFAULT 0,
romsd2 numeric(4) DEFAULT 0,
romsd3 numeric(4) DEFAULT 0,
romsd4 numeric(4) DEFAULT 0,
romqsp numeric(4) DEFAULT 0,
romqsj numeric(4) DEFAULT 0,
romqvp numeric(4) DEFAULT 0,
romqvj numeric(4) DEFAULT 0,
rompsb numeric(5,1) DEFAULT 0,
romama numeric(4,1) DEFAULT 0,
romver numeric(4,1) DEFAULT 0,
romazu numeric(4,1) DEFAULT 0,
romaum numeric(6) DEFAULT 0,
rompdc numeric(5,2) DEFAULT 0,
romdes numeric(12,3) DEFAULT 0,
romplc numeric(12,3) DEFAULT 0,
romtra date,
romme1 numeric(5,2) DEFAULT 0,
romme2 numeric(5,2) DEFAULT 0,
romme3 numeric(5,2) DEFAULT 0,
romme4 numeric(5,2) DEFAULT 0,
romme5 numeric(5,2) DEFAULT 0,
romme6 numeric(5,2) DEFAULT 0,
romme7 numeric(5,2) DEFAULT 0,
romlar numeric(5,2) DEFAULT 0,
romcom numeric(5,2) DEFAULT 0,
romrom numeric(7) DEFAULT 0,
romlot char(3),
rombrve numeric(6) DEFAULT 0,
romtabe numeric(4) DEFAULT 0,
romveri numeric(9) DEFAULT 0,
romclas numeric(6) DEFAULT 0,
rombala numeric(6) DEFAULT 0,
romgmo numeric(5,2) DEFAULT 0,
sr_recno bigserial NOT NULL ,
sr_deleted char(1) NOT NULL DEFAULT ' '::bpchar,
indkey_001 varchar(254),
CONSTRAINT granol_sie3300_dbf_sr_recno_key UNIQUE (sr_recno)
)
WITHOUT OIDS;
ALTER TABLE granol_sie3300_dbf OWNER TO postgres;
-- Index: granol_sie3300_dbf_sr
-- DROP INDEX granol_sie3300_dbf_sr;
CREATE INDEX granol_sie3300_dbf_sr
ON granol_sie3300_dbf
USING btree
(sr_recno);
-- Index: granol_sie330a_000001
-- DROP INDEX granol_sie330a_000001;
CREATE INDEX granol_sie330a_000001
ON granol_sie3300_dbf
USING btree
(indkey_001);
--------------------------
-- Table: sif50_mov1000_dbf
-- DROP TABLE sif50_mov1000_dbf;
CREATE TABLE sif50_mov1000_dbf
(
movcon numeric(5) DEFAULT 0,
movunc numeric(2) DEFAULT 0,
movure numeric(2) DEFAULT 0,
movufa numeric(2) DEFAULT 0,
movnpr numeric(14) DEFAULT 0,
movdem date,
movdoc numeric(9,2) DEFAULT 0,
movnnr char(10),
movfor numeric(5) DEFAULT 0,
movcme numeric(6) DEFAULT 0,
movput numeric(14,2) DEFAULT 0,
movval numeric(14,2) DEFAULT 0,
movicm numeric(14,2) DEFAULT 0,
movfun numeric(14,2) DEFAULT 0,
movqte numeric(12,3) DEFAULT 0,
movdqq numeric(12,3) DEFAULT 0,
movaum numeric(12,3) DEFAULT 0,
movpli numeric(12,3) DEFAULT 0,
movren numeric(12,3) DEFAULT 0,
movmov numeric(3) DEFAULT 0,
movimp numeric(5,2) DEFAULT 0,
movard numeric(5,2) DEFAULT 0,
movumi numeric(5,2) DEFAULT 0,
movimpo numeric(5,2) DEFAULT 0,
movardo numeric(5,2) DEFAULT 0,
movumio numeric(5,2) DEFAULT 0,
movobs numeric(10) DEFAULT 0,
movtks numeric(6) DEFAULT 0,
movtra date,
movcov numeric(5) DEFAULT 0,
movcoa numeric(5) DEFAULT 0,
movsit numeric(1) DEFAULT 0,
movqut char(3),
movsaf char(1),
movesvd numeric(5,2) DEFAULT 0,
movesvo numeric(5,2) DEFAULT 0,
movgmo numeric(5,2) DEFAULT 0,
movtgmo char(1),
movfgmo char(1),
sr_recno bigserial NOT NULL ,
sr_deleted char(1) NOT NULL DEFAULT ' '::bpchar,
indkey_001 varchar(254),
CONSTRAINT sif50_mov1000_dbf_sr_recno_key UNIQUE (sr_recno)
)
WITHOUT OIDS;
ALTER TABLE sif50_mov1000_dbf OWNER TO postgres;
GRANT ALL ON TABLE sif50_mov1000_dbf TO postgres;
GRANT SELECT ON TABLE sif50_mov1000_dbf TO xi;
-- Index: sif50_mov1000_dbf_sr
-- DROP INDEX sif50_mov1000_dbf_sr;
CREATE INDEX sif50_mov1000_dbf_sr
ON sif50_mov1000_dbf
USING btree
(sr_recno);
-- Index: sif50_mov100a_000001
-- DROP INDEX sif50_mov100a_000001;
CREATE INDEX sif50_mov100a_000001
ON sif50_mov1000_dbf
USING btree
(movcon, movunc, movnpr, sr_recno);
-- Index: sif50_mov100a_000006
-- DROP INDEX sif50_mov100a_000006;
CREATE INDEX sif50_mov100a_000006
ON sif50_mov1000_dbf
USING btree
(movcon, movunc, movnpr, sr_recno);
-- Index: sif50_mov100b_000006
-- DROP INDEX sif50_mov100b_000006;
CREATE INDEX sif50_mov100b_000006
ON sif50_mov1000_dbf
USING btree
(movcon, movunc, movfor, movdoc, movval, sr_recno);
-- Index: sif50_mov100c_000006
-- DROP INDEX sif50_mov100c_000006;
CREATE INDEX sif50_mov100c_000006
ON sif50_mov1000_dbf
USING btree
(movnnr, movcon, movunc, movfor, movval, sr_recno);
-- Index: sif50_mov100d_000006
-- DROP INDEX sif50_mov100d_000006;
CREATE INDEX sif50_mov100d_000006
ON sif50_mov1000_dbf
USING btree
(movtks, movure, movcon, movunc, movdoc, sr_recno);
create index qr_dbf_sie3000_log_12345 on qr_dbf_sie3000_log (cnrnum);
create index granol_sie3000_dbf_12345 on granol_sie3000_dbf (cnrnum ) ;
create index granol_sie3000_dbf_12346 on granol_sie3000_dbf (cnrsis ) ;
create index granol_sie3200_dbf_12345 on granol_sie3200_dbf (inrnum,
inrndc);
create index granol_sie3200_dbf_12346 on granol_sie3200_dbf (inrdco );
create index granol_sie3200_dbf_12347 on granol_sie3200_dbf (inrcmv );
create index granol_sie3300_dbf_12345 on granol_sie3300_dbf
(romnum,romtip);
create index granol_sie3000_dbf_12347 on granol_sie3000_dbf (cnrlrt);
create index granol_sie3000_dbf_12348 on granol_sie3000_dbf ( cnrnfr );
create index sif50_mov1000_dbf_12345 on sif50_mov1000_dbf (movnpr );
Atenciosamente
Luiz Rafael
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
