pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [SQL] OID & indexes.
4+ messages / 4 participants
[nested] [flat]
* Re: [SQL] OID & indexes.
@ 1999-09-21 15:10 Tom Lane <tgl@sss.pgh.pa.us>
parent: raptor <raptor@unacs.bg>
2 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 1999-09-21 15:10 UTC (permalink / raw)
To: raptor <raptor@unacs.bg>; +Cc: pgsql-sql
raptor <raptor@unacs.bg> writes:
> Is the OID fileld indexed and if not can I create index on it.
No, and yes. OID is just like any regular column as far as
indexing is concerned. You should make an index on it if you
plan to do lots of 'WHERE oid = something' queries.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] OID & indexes.
@ 1999-09-21 15:24 Bruce Momjian <maillist@candle.pha.pa.us>
parent: raptor <raptor@unacs.bg>
2 siblings, 0 replies; 4+ messages in thread
From: Bruce Momjian @ 1999-09-21 15:24 UTC (permalink / raw)
To: raptor <raptor@unacs.bg>; +Cc: pgsql-sql
> hi,
>
> Is the OID fileld indexed and if not can I create index on it.
It is not indexed by default. You have to create an index on it.
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 4+ messages in thread
* OID & indexes.
@ 1999-09-21 21:56 raptor <raptor@unacs.bg>
0 siblings, 3 replies; 4+ messages in thread
From: raptor @ 1999-09-21 21:56 UTC (permalink / raw)
To: pgsql-sql
hi,
Is the OID fileld indexed and if not can I create index on it.
Thanx
=====
iVAN
raptor@unacs.bg
=====
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] OID & indexes.
@ 1999-09-22 12:30 José Soares <jose@sferacarta.com>
parent: raptor <raptor@unacs.bg>
2 siblings, 0 replies; 4+ messages in thread
From: José Soares @ 1999-09-22 12:30 UTC (permalink / raw)
To: raptor <raptor@unacs.bg>; +Cc: pgsql-sql
raptor ha scritto:
> hi,
>
> Is the OID fileld indexed and if not can I create index on it.
>
The OID field is not indexed by default but you can create an index on
it as:
create index idx_name on table_name (oid);
José
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-09-22 12:30 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-09-21 21:56 OID & indexes. raptor <raptor@unacs.bg>
1999-09-21 15:10 ` Tom Lane <tgl@sss.pgh.pa.us>
1999-09-21 15:24 ` Bruce Momjian <maillist@candle.pha.pa.us>
1999-09-22 12:30 ` José Soares <jose@sferacarta.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox