Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group