Re: Performance

A mar, 16 may 2000, Diego Schvartzman va escriure:
> ....
> TABLE STRUCTURE:
> CREATE TABLE "d_cue" (
>  "clave" character(7),
>  "nombre" character varying(60),
>  "calle" character varying(45),
>  "referencia" character varying(60),
>  "telefono" character varying(15),
>  "cp" int4,
>  "zona" int4,
>  "fraccion" character(2),
>  "radio" character(2),
>  "cooperadora" int4,
>  "d_cooperadora" character varying(50),
>  "confesional" int4,
>  "d_confesional" character varying(50),
>  "arancel" int4,
>  "d_arancel" character varying(50),
>  "categoria" int4,
>  "d_categoria" character varying(50),
>  "permanencia" int4,
>  "d_permanencia" character varying(50),
>  "alternancia" int4,
>  "d_alternancia" character varying(50),
>  "cod_jur" character varying(15),
>  "matric" character,
>  "periodo_func" int4,
>  "d_periodo_func" character varying(50),
>  "var1" character varying(15),
>  "var2" character varying(15),
>  "var3" character varying(15),
>  "var4" character varying(15),
>  "var5" character varying(15),
>  "var6" character varying(15),
>  "vat1" character(6),
>  "d_vat1" character varying(50),
>  "vat2" character(6),
>  "d_vat2" character varying(50),
>  "vat3" character(6),
>  "d_vat3" character varying(50),
>  "vat4" character(6),
>  "d_vat4" character varying(50),
>  "vat5" character(6),
>  "d_vat5" character varying(50),
>  "vat6" character(6),
>  "d_vat6" character varying(50),
>  "direle" character varying(30),
>  "barrio" character varying(40),
>  "nuevo" character,
>  "d_nuevo" character varying(50),
>  "turnos" character varying(255),
>  "tipos" character varying(255),
>  "ciclos" character varying(255),
>  "f_nf" character(10),
>  "agregado" int4);
> ...


Argggggggggg, You should read a database's book.

          ----------------
              Sime� Reig
           simeo@tinet.org
          -----------------