Re: Activate Index

Well , My table has 380000 records!!!


>From: "Mattias Kregert" <mattias@kregert.se>
>To: "Edwin Quijada" <listas_quijada@hotmail.com>
>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" <listas_quijada@hotmail.com>
>To: <pgsql-general@postgresql.org>
>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/