Re: [SQL] OID & indexes.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: raptor <raptor(at)unacs(dot)bg>
Cc: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgreSQL(dot)org>
Subject: Re: [SQL] OID & indexes.
Date: 1999-09-21 15:10:30
Message-ID: 21907.937926630@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

raptor <raptor(at)unacs(dot)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

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 1999-09-21 15:23:10 Re: [SQL] Subselect performance
Previous Message Stuart Rison 1999-09-21 14:58:08 Re: [SQL] Subselect performance