hat is the best setup
>
>
>
> >From: "scott.marlowe" <[EMAIL PROTECTED]>
> >To: Edwin Quijada <[EMAIL PROTECTED]>
> >CC: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
> >Subject: Re: [GENERAL] Activate Index
> >Date: Thu, 4 Sep 2003
IL PROTECTED]>
> >To: Edwin Quijada <[EMAIL PROTECTED]>
> >CC: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
> >Subject: Re: [GENERAL] Activate Index
> >Date: Thu, 4 Sep 2003 08:58:57 -0600 (MDT)
> >
> >What query are you running?
> >
>
setup
From: "scott.marlowe" <[EMAIL PROTECTED]>
To: Edwin Quijada <[EMAIL PROTECTED]>
CC: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: Re: [GENERAL] Activate Index
Date: Thu, 4 Sep 2003 08:58:57 -0600 (MDT)
What query are you running?
If you run
select
ll small for a
workgroup or enterprise class database.
On Thu, 4 Sep 2003, Edwin Quijada wrote:
>
> Well , My table has 38 records!!!
>
>
> >From: "Mattias Kregert" <[EMAIL PROTECTED]>
> >To: "Edwin Quijada" <[EMAIL PROTECTED]>
> &
Well , My table has 38 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 hav
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 delp
