select * from table where oid = number;

From: "Taral" <taral(at)mail(dot)utexas(dot)edu>
To: <pgsql-general(at)hub(dot)org>
Subject: select * from table where oid = number;
Date: 1998-10-08 19:48:08
Message-ID: 001001bdf2f4$92dad980$3b291f0a@taral
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a reason why this occurs?

table=> explain select * from data where oid = 18522;
NOTICE: QUERY PLAN:

Seq Scan on data (cost=0.00 size=0 width=120)

EXPLAIN

I would have expected an index scan or something.

TAral

Responses

Browse pgsql-general by date

  From Date Subject
Next Message La Mancha de la Calabaza que Ladra 1998-10-08 20:31:44
Previous Message Evan Howarth 1998-10-08 19:24:00 Re: [GENERAL] SELECT Date