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
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 us
an explain
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
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 select