On Wed, Nov 10, 2004 at 12:22:17PM +0100, Cao Duy wrote:
> there is an index on customer_id
>
> create table customer(
> ...
> CONSTRAINT customer_pkey PRIMARY KEY (customer_id),
> ...
> )
Oh, sorry, I missed it among all the foreign keys. :-) Anyhow, as others have
pointed out, try doing a selec
Am Mi, den 10.11.2004 schrieb Steinar H. Gunderson um 11:17:
> On Wed, Nov 10, 2004 at 10:35:50AM +0100, Cao Duy wrote:
> > here is my simple select-statement:
> > SELECT * FROM CUSTOMER WHERE CUSTOMER_ID=5
>
> It seems like you're missing an index on customer_id. Set it to PRIMARY KEY
> or do an
From: "Cao Duy" <[EMAIL PROTECTED]>
>
> here is my simple select-statement:
> SELECT * FROM CUSTOMER WHERE CUSTOMER_ID=5
>
> the result appears after about 27 sec.
>
> what's wrong?
> ...
> CREATE TABLE public.customer
> (
> customer_id bigserial NOT NULL,
you do not specify version or show u
On Wed, Nov 10, 2004 at 10:35:50AM +0100, Cao Duy wrote:
> here is my simple select-statement:
> SELECT * FROM CUSTOMER WHERE CUSTOMER_ID=5
It seems like you're missing an index on customer_id. Set it to PRIMARY KEY
or do an explicit CREATE INDEX (followed by an ANALYZE) and it should be a
lot fas
Hi all
I have a table with ca. 4Mio Rows.
here is my simple select-statement:
SELECT * FROM CUSTOMER WHERE CUSTOMER_ID=5
the result appears after about 27 sec.
what's wrong?
the same statement on mysql takes 1 milisec.
please help
here is the structur of the table
CREATE TABLE public.custome