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(at)tinet(dot)org
-----------------