Re: How to optimize this query?

Hello Markus,

Wednesday, March 22, 2006, 8:12:35 PM, you wrote:

MB> Well, send the table descriptions, please.
\d towarmax3               | smallint               | default 0max4               | smallint               | default
0typik             | character varying(1)   | default '_'::character varyingid_grupa_rabatowa  | integer
|not null default 0id_jednostka_miary | integer                | not null default 0id_vat             | integer
      | not null default 0id_typ_towaru      | integer                | not null default 0id_dostawcy        | integer
             | not null default 0grupa_produkcji    | smallint               |dodatek            | boolean
 | not null default falsepoliczalne         | boolean                | not null default truesimport            |
charactervarying(50)  |czy_procent        | boolean                | not null default falsesubtyp             |
charactervarying(35)  |kontofk            | character varying(40)  |typks              | character varying(30)
|nazwarodzaju      | character varying(50)  |nazwakatalogu      | character varying(250) |waluta             |
charactervarying(3)   | not null default 'PLN'::character varyingbank               | character varying(5)   | not null
default'NBP'::character varyingprocent_do_wyceny  | smallint               | not null default 0waga               |
numeric(24,4)         | not null default 0cena_z             | numeric(24,4)          | not null default
0ilosc_paczkowa    | numeric(24,4)          | not null default 0ilosc_jed          | numeric(24,4)          | not null
default1ilosc_nom          | numeric(24,4)          | not null default 1odpad              | numeric(24,4)          |
notnull default 0cena_jedn          | numeric(24,4)          | not null default 0roboczojednostka   | numeric(24,4)
    | not null default 0
 
Indexes:   "towar_pkey" PRIMARY KEY, btree (id_towar)   "towar_key1" btree (key1)   "towar_key2" btree (key2)
Foreign-key constraints:   "$1" FOREIGN KEY (id_grupa_rabatowa) REFERENCES grupa_rabatowa(id_grupa_rabatowa) ON UPDATE
CASCADEON DELETE SET NULL   "$2" FOREIGN KEY (id_jednostka_miary) REFERENCES jednostka_miary(id_jednostka_miary) ON
UPDATECASCADE ON DELETE SET NULL   "$3" FOREIGN KEY (id_vat) REFERENCES vat(id_vat) ON UPDATE CASCADE ON DELETE SET
NULL  "$4" FOREIGN KEY (id_typ_towaru) REFERENCES typ_towaru(id_typ_towaru) ON UPDATE CASCADE ON DELETE SET NULL   "$5"
FOREIGNKEY (id_dostawcy) REFERENCES dostawcy(id_dostawcy) ON UPDATE CASCADE ON DELETE SET NULL
 
Triggers:   towar_domyslne BEFORE INSERT ON towar FOR EACH ROW EXECUTE PROCEDURE domyslne_ustawienia()   zmiana_wagi
AFTERUPDATE ON towar FOR EACH ROW EXECUTE PROCEDURE waga_przelicz()
 



-- 
Best regards,Maciej                            mailto:piechcio@isb.com.pl