From: | "Edwin Quijada" <listas_quijada(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Activate Index |
Date: | 2003-09-04 14:02:25 |
Message-ID: | BAY1-F61m1joKIB5i5Q00022f42@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi!!
This is my first post to the list. I have a problem.
I have a table with a two index , int4, but when I do a search using the
field indexed but when I applied an explain to the query it says Seq Scan ,
I mean , that it doesnot use the index.
I cant use the cast field::int4 because I use delphi and delphi does not
support this.
I know there is a command to activate index aand always postgrres will be
the index
Which are this command???
Anyone knows?
*-------------------------------------------------------*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-747-2787
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo
comun"
*-------------------------------------------------------*
_________________________________________________________________
¿Estás buscando un auto nuevo? http://www.yupimsn.com/autos/
From | Date | Subject | |
---|---|---|---|
Next Message | psql-mail | 2003-09-04 14:07:37 | Re: postmaster crashing |
Previous Message | Tom Lane | 2003-09-04 13:54:21 | Re: More than 1024 connections from the same c-backend |