Well , My table has 380000 records!!!
From: "Mattias Kregert" <[EMAIL PROTECTED]> To: "Edwin Quijada" <[EMAIL PROTECTED]> Subject: Re: [GENERAL] Activate Index Date: Thu, 4 Sep 2003 15:58:33 +0200
Hello Edwin,
The index will be used automatically when you have enough rows in the table. For tables with a small number of rows, a seq scan will be made because it is actually faster than using the index with a small number of rows.
You also have to remember to run VACUUM from time to time, so that the statistics are updated so the planner can see how many rows are in the table.
/Mattias
----- Original Message ----- From: "Edwin Quijada" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 04, 2003 4:02 PM Subject: [GENERAL] Activate Index
> 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/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
_________________________________________________________________ ¿Estás buscando un auto nuevo? http://www.yupimsn.com/autos/
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
